Emilia Maxim.

F

Fysh1

I took your advice and it worked great I want to thank you
for your assistance ClinicTypeID works! I have been going
in circles for a couple days on this. However, for some
reason I can't get the customerID to go into the
tblVisits. Do you have any suggestions to fix this? Here
is my SQL for the form.

SELECT tblVisit.VisitID, tblVisit.CustomerID,
tblCustomer.CustomerID, tblVisit.CustDate,
tblVisit.Timein, tblVisit.ClinicType, tblCustomer.FName,
tblCustomer.LName,FROM tblCustomer INNER JOIN tblVisit ON
tblCustomer.CustomerID = tblVisit.CustomerID;

Should I be placing my combobox and listbox into a subform
and then have master/child link on the customerID?
Thanks for any further help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed with multiple confusion 0
Order Entry type form to add to three tables 12
Master-Child Form Linkages 3
report help needed thanks 1
Filter Options 4
Still need assistance 3
Filter a subform combo with a text box value on the main form 6
Slow form 2

Top