I am experiencing a quite frustrating issue with the command button opening my contact form from the customer form command button. The same issue with what you showed in this video (TimeStamp 5:17), if that customer doesnt have a contact, (New) shows up in the contact ID, but the customer ID slot is blank. I opened the contact Form's ContactID Combo box properties, went to data tab, default values and entered exactly how you typed in before (=FORMS!CustomerF!CustomerID). This worked on my appointmentF box but it is not working in my Contact form. I deleted and recreated the combo box in my contactF several times testing pulling the data from different forms/queries and that didnt help. I recreated the command button multiple times making sure its pullin from the correct locations. No Joy.
Zachary PritzOP
@Reply 19 months ago
Zachary PritzOP
@Reply 19 months ago
Zachary PritzOP
@Reply 19 months ago
Zachary PritzOP
@Reply 19 months ago
Any guidance will be greatly appreciated! Thank you so much for your time!
Zachary PritzOP
@Reply 19 months ago
Here is a picture of the same customer ID field in my AppointmentF that DOES work properly pulling up the current customer ID from the customerF.
Zachary PritzOP
@Reply 19 months ago
Zachary PritzOP
@Reply 19 months ago
I even tried to simplify the control source by selecting the customerF, then trying CompanyNullFullNameQ where I have the full name sorted.
James Hopkins
@Reply 19 months ago
Have you tried:
Forms!ContactF!ComboBoxName = CustomerID
Also, what in the of the Contact Form Combo Box Columns?
Zachary PritzOP
@Reply 19 months ago
Thanks James! Just tried your suggestion but it came back with the same results. For the collumns in the combo box, I used the field [CompanyNullFullName] in the CompanyNullFullNameQ. quick if then field if the company name is null then it inserts the full name. I tried to reference a full name in a past attempt as well as referencing the CustomerT directly. Same NEG RES each time.
Zachary PritzOP
@Reply 19 months ago
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 2.