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

Auto Populate fields

P: 1

I am need of some help with my database design. I am no expert to Access/VBA by any means.

I have a form (see attached) which has a field called PropertyID. Originally I had Indexed set to yes(duplicates OK). When I would enter an ID the manufacturer, model, and serial # fields would auto populate. I then realized that with that setting users can enter duplicate data. When I changed Indexed to Yes(No Duplicates) I lost the auto populate function.

I would like to have the best of both worlds. I need the field to stay Unique as well as populate those 3 fields.

Thank you for your help.

Attached Images
File Type: jpg Relationships.jpg (28.6 KB, 376 views)
File Type: jpg FormDetail.jpg (42.7 KB, 400 views)
Mar 5 '12 #1
Share this Question
Share on Google+
1 Reply

P: 759
I think there are 3 ways to do that:

1) Create a separate query and set it as record source for your form;
2) Edit the record source for your form then change in this place the query.
3) Define for each table a form and use this as sub-form in their parent form.
Mar 6 '12 #2

Post your reply

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