By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,094 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

Autofill Address, City, etc.

P: 30
I used Access about 5 years ago but mostly to do queries. I am now trying to creating a DB that will allow users to order items and I don't think I've ever created a form. I have the Access for Dummies and the Access Forms & Reports for Dummies but it only got me so far. I have so many questions that I don't know where to begin.

I have a table named CustomerName and I was able to create the field called CustomerName on the form and have a combo box, drop down box to select the customer name. Now, I ready to add the address, city, etc which I want autofilled depending on who you pick.

I have a query set up that has all the fields I want in the form called Cust.

I found something on this forum that explains how to do this, but it either didn't work or I was putting the expression in the wrong place.

Currently I have the recordsource of the form set to the Cust query.

What's next?

Any help is appreciated.

Thanks
Mary
Mar 4 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.