Our academic system rewards people who know a lot of stuff... but at the end of the day who do you want: the person who can figure things out that they've never seen before or the person who can rattle off a bunch of facts?
NOTE: If you add a new customer and IMMEDIATELY try to add a contact for him without first saving the customer record (moving off of it, or closing the customer form) you will find that the customer doesn't show up in the combo box on the contact form. This is because the customer record hasn't been saved to the table yet.
You can fix this problem by creating a REFRESH button using the command button wizard: Form Operations > Refresh Form Data. You just have to click on this button before trying to make a contact.
In my Access 300+ Advanced series when we get into programming, I'll teach you how you can add the refresh code (Me.Refresh) to the VBA of your OPEN CONTACTS button and do all of this in one step.
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
Microsoft Access 202.
