The dumbing down of America is most evident in the slow decay of substantive content in the enormously influential media... credulous presentations on pseudoscience and superstition... a kind of celebration of ignorance
IMPORTANT ADDENDUM: After you make your OPEN ORDERS button, you will notice that if you add a customer and then immediately try to add a new order BEFORE you save the customer record to the table (move off of it, or close and reopen the form) the customer will not show up in the combo box on the order form. This is because the customer doesn't exist in the customer table yet.
You can fix this problem by making sure you SAVE the record to the table first. The easiest way to fix this is to put the following line BEFORE your DoCmd.OpenForm line:
Me.Refresh
This refreshes the current record (saves it to the table) and then when you visit the order form, it's there.
I cover Me.Refresh in detail in Access 305, but I didn't think of this problem at the time I made this class.
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 301.
