Richard, I have a question about using Forms]![CustomerF]![ID] to set the default value of a combobox, as in your example (Access 2010 expert2, lesson 4, 9:40). If I wanted a button in two different forms (CustomerListF and ContractExpirationF) to open the ContactF, would I use = ([Forms]![CustomerF]![ID] Or [Forms]![ContractExpirationF]![ID]) in the Default Value property of the combobox in the ContactF?
Thanks,
Ray Kimber
Reply from Richard Rost:
If you do it this way, you'll have to decide which form you want to supply the default value. It can't be both.
Later on, when we get into programming, I'll show you how you can use VBA in the button that opens the form to supply the default value.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 2.