Data entry

[BillyDo]

Hi all

Real newby question here but I cant seem to figure this out...

I have a table (tblEvents) and I want to design a form which will be used to enter data into this table.

I want the user to be able to select from a combobox (which will be populated from tblVenue). I can do this bit but I cant figure out how to then have the selection populate the venue table.

Many thanks for any help

 

[GinaWhipp]

Okay, now that's a bit confusing... you want the Combo Box on the form to populate from tblVenue but you also want to write data to that same table? Perhaps you mena you want to be able to add new Venues if not on the list?

 

[BillyDo]

Okay, now that's a bit confusing... you want the Combo Box on the form to populate from tblVenue but you also want to write data to that same table? Perhaps you mena you want to be able to add new Venues if not on the list?

Hi thanks for your reply.

Sorry- I have not made myself clear. I made an error in my original post!

The combobox should be populated from the venue table- but should update a 2nd table (Sales)

Hope that makes it clearer!

 

[GinaWhipp]

Have you considered and UPDATE query? You can place in the After_Update of the Venue Combo Box.