Autofill not working - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Autofill not working

Thomas Colley

17 months ago

I am a stained glass artist, I decided to make a stained glass pricing DB. I have the QuoteF where the customer address will autofill based off the CustomerID from a Combobox. everything fills fine except the phone number. what am I missing? This is what I am using:
EmailAddress = Nz(DLookup("EmailAddress", "CustomerT", "CustomerID=" & CustomerCmb), "")
CustomerNumber = Nz(DLookup("CustomerNumber", "CustomerT", "CustomerID=" & CustomerCmb), "")

	Sami Shamma @Reply 17 months ago
what is the row source of your CustomerCmb?

	Alex Hedley @Reply 17 months ago
Did you want to share the code for retrieving the phone number too?

	Thomas Colley OP @Reply 17 months ago
Row Source is SELECT [CustomerLFQ].[CustomerID], [CustomerLFQ].[LF] FROM CustomerLFQ ORDER BY [LF]; CustomerNumber = Nz(DLookup("CustomerNumber", "CustomerT", "CustomerID=" & CustomerCmb), "")

	Thomas Colley OP @Reply 17 months ago
Good morning, Any ideas on this

	Alex Hedley @Reply 17 months ago
1. Is `CustomerNumber` the phone number? 2. Row Source is for `CustomerCmb`?

	Alex Hedley @Reply 17 months ago
Does `SELECT CustomerNumber FROM CustomerT WHERE CustomerID = 1` return anything?

	Thomas Colley OP @Reply 17 months ago
Alex, where do I put that

	Thomas Colley OP @Reply 17 months ago
I figured it out, in the CustomerT i spelt CustomerNumber wrong i had it CustomerNunber everywhere else i had it spelt right. it is now working. thanks for your help.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View