Absolute beginner

Topic

New Reply

Hi everyone,
I know this is probably an easy question but for an absolute beginner it’s hard to get around, especially if
the help files don’t work.

I have a form that accepts user input, one of the controls is a combo box who’s row source contains values from a
select operation on a different table.
All of the controls are bound to another table so that the data written to them will be stored there. I need it to populate the rest of the form (and so update the table) based on a select query from the values of the original combo box. Am I making any sense?
I know it’s a really fundamental problem but I’d appreciate
any help. Thanks.
Rob

Reply | Quote

Replies

Let me see if I understand: (My example) You have a form for “Sales”. This form has a combo box for “Item”, which will select a list of items that can be sold. When you select “Snow Shovel”, then it populates the form with the snow shovel information. Is my understanding correct? If so I may be able to help you.

Reply | Quote

That’s exactly right. The value from the combo box hopefully should cause related values to populate other controls on the form, each of which are bound to a table where these values will be stored.
Thanks for any help.
robin

Reply | Quote

Why do you want to store the same information in more than one place in the database? This could create real headaches for you down the road.

Reply | Quote

well the idea is to have one table to store client info that won’t change much – client address details etc.
In the other(s) store info on past transactions with these clients.
Hopefully a one to many relationship(s).

Eg. If there is a problem with a delivery, paperwork must be typed up and stored in the database as a kind of online archive – no paper involved.
What I’m trying to do is to place a combo box on the form
for incorrect deliveries(for example)that once a purchase order number is selected will fill up the details of that past transaction. The user will then fill up any other details required and archive it.
Am I making any sense? I’m probably not being very clear about all this.

Reply | Quote

It sounds like you are trying to use the combo box to search for items in the main table. If so then the combo box should be unbound, which means that the result of selecting an item from the combo box does not store a value anywhere. To do this the combo box should not have anything in the Control Source property and in design view the combo box will have “unbound” written in it. Probably the easiest way to make this combo box is to use the wizard to create it for you. If you want to do it manually then you will have to create an event procedure that will search for the record you are after when the combo box is updated ie you will need to create an event procedure for the After Update event of the combo box.

Reply | Quote