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

Combo Box selection populates text boxes

P: 6
Hello,
I am very new at Access & VBA so I hope you understand what I am asking.

I have a form that displays information about an apartment building. I created a combo box to list all of the apartment Units/numbers. Under neath the combo box I have 5 different text boxes for dates for construction. Examples of the dates are "start Date", "Application Date", "Completion Date". The user will populate these text boxes with the dates, as they happen. If the user (landlord) receives an application for Apt. 101, the user will select 101 from the combo and place the date in the "Application Received:" Text box. Save and Close. When the job is completed, select Apt 101 again and place the date the job was Closed.

I am having trouble identifying the dates for each apartment number. Each apartment will have different dates. I think it should be a VBA code on the OnChange event of the combo box. Also, I have the combo box as Unbound.

Can you please tell me how to do this?
Thank you!
May 4 '10 #1

✓ answered by NeoPa

It seems like you need a simple form bound to the table with the dates in, but which has an unbound ComboBox in the header for filtering the records. Example Filtering on a Form gives some examples of how this can be done.

Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
It seems like you need a simple form bound to the table with the dates in, but which has an unbound ComboBox in the header for filtering the records. Example Filtering on a Form gives some examples of how this can be done.
May 5 '10 #2

Post your reply

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