That's one option.
How would I ensure that CustomerID's that have already made choices over what products they wish to purchase (and therefore, have their details stored in a separate table) are not present in the combo box?
To rephrase, I only want CustomerID's that haven't made their purchase choices available for picking.
Kenny24
Last Activity: Jan 15 '12, 08:07 PM
Joined: Dec 21 '11
Location:
-
How to check data entered into a form is accurate with data in a table?
I have a form (Form A), where I require the user to enter a CustomerID which they have created using a separate form (Form B) and which the data is stored in (Table B).
How would I go about checking the CustomerID they enter into Form A is an exact match to one of the CustomerID's stored in Table B?
I guess I'm struggling with finding the code to cross-reference between sources of data.
Any help or advise... -
How to count the total value of selected option boxes
Hope someone can help with this problem I have!
On Access, I have a combination of 10 'true/false' buttons that can be selected. Eg. 10 different types of cake.
The user can select any amount of cake.
Each cake has a numeric value.
How can I calculate, using VBA, the total value of chosen cakes?
Currently, I have a very long If statement where I identify whether a button has been pressed...
No activity results to display
Leave a comment: