3 linked tables.
1. tblClientInformation (linked one to many with tblWorkshopRegistrations via ClientID - primary key)
2. tblWorkshopListings - details of what workshops we offer (linked one to many with tblWorkshopRegistrations via WorkshopID - primary key)
3. Workshop Registrations (linked many to one with tblWorkshopListings via WorkshopID - primary key here is WorkshopRegID)
I want to create a form that lets clients register for workshops (sounds easy!).
I would like to be able to setup a combo box to fill in client information on the form, (i.e. can start to type in last name, the first name, clientID etc. gets filled in automatically). Then in a drop down box, select the workshop they want. The dropdown box would then display the workshop listings details (so you can confirm when / where it is with them on the phone etc).
I have most of it working, until I drop in a combo box - then I get runtime errors '3201' I think. I have been very careful to link child - master forms (when I subform it).
Any help or strategies greatly appreciated.
Cheers,
Steve
1. tblClientInformation (linked one to many with tblWorkshopRegistrations via ClientID - primary key)
2. tblWorkshopListings - details of what workshops we offer (linked one to many with tblWorkshopRegistrations via WorkshopID - primary key)
3. Workshop Registrations (linked many to one with tblWorkshopListings via WorkshopID - primary key here is WorkshopRegID)
I want to create a form that lets clients register for workshops (sounds easy!).
I would like to be able to setup a combo box to fill in client information on the form, (i.e. can start to type in last name, the first name, clientID etc. gets filled in automatically). Then in a drop down box, select the workshop they want. The dropdown box would then display the workshop listings details (so you can confirm when / where it is with them on the phone etc).
I have most of it working, until I drop in a combo box - then I get runtime errors '3201' I think. I have been very careful to link child - master forms (when I subform it).
Any help or strategies greatly appreciated.
Cheers,
Steve
