When replacing Lead Source and Shipping combo boxes in CustomerF in Lesson 4 starting @ 15:05, I still have the form saved with the CustomerQ query as the Record Source and there are no missing control errors because that query is joined to the LeadSourceT and ShippingT.
When I change Record Source to CustomerT I see the control field errors. Did I miss being told to stay with CustomerT for the Record Source for CustomerF form?
Thank you - Mike M.
Daniel de Koning
@Reply 3 years ago
Hi Mike, based on the videos (starting from Beginner 8 till Expert 1), I would say that the Record Source was never changed into CustomerQ in CustomerF (see Beginner 8 in Lesson 1 @ 03:20, where the Record Source was changed from a SELECT Statement into CustomerT). Although I fast forwarded the videos, I didn't saw that CustomerQ was changed to include LeadSourceT and ShippingT into the Query and since it didn't give you an error using CustomerQ, it's probably ok (hopefully somebody else can correct me if I'm wrong), but make sure you have setup the Relational Table as instructed in Expert 1, lesson 2.
Kind regards, Dani'l
Michael MunitzOP
@Reply 3 years ago
Thanks Daniel. I actually deleted the fields and tables and went back to Lesson 8 and started over. I must have been getting tired because I noticed a few things that I did not do according to the videos. I am just now starting Expert 1 and modifying LeadSourceT and ShippingT to add primary key fields, so we'll see what happens!
Thanks again...Mike
Michael MunitzOP
@Reply 3 years ago
Doing it all over was the best thing I could have done. Everything I do now is matching the lesson steps and I am almost done. Again, I must have been tired.
I should have listened to Richard in Slow speed when I was tired. When he is in slow speed it reminds me of a couple of scenes in "Fear and Loathing in Las Vegas" lol.
Mike M
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 1.