Use combo box to update other fields
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I know I can make a huge form with all the fields listed one under the other on the page, and the user would then scroll down and fill each box with data. However, I would prefer to make the user's life easy and allow the user to use a combo box to select wich field they want to work on, and then a box right next to the combo would show the value of the current record for that field.
(I know that I can set the combo box Field List property with a list of field names in it, but can I link this to a text box so that anything that is written or displayed within it relates to the field displayed in the combo box
For example, I have the following values in a table.
So, I did the following.
The Row Source of the combo box needs to include both columns (fields).
This worked (when entering data in name field, number field updates in the form) but now I am finding when I add data thru the form the number fields are not updating in the table. All the other fields in the form are updating.
: my update works when I use the record navigation buttons down on the bottom but I want to use combo boxes to select the record rather than toggling through the records one by one.
Btw The result of the query is Only one line of data
DoCmd.DoMenuItem acFormBar, acRecordsMenu, 5, , acMenuVer70
I put this in the After Update on the first combo box and I tried it on the On Got Focus and they both work fine except there is a 5 - 10 second delay before the 2nd combo box populates. Any ideas on how I can make the second Combo Box populate faster
Example: if combo box = yes, then text box = .02, if combo box = no, then text box = 0
I think I can do this with a macro in the after update of the combo box but I'm not sure about the syntax.
This is on one form built off one table. The text box is not on the form, just the combo box
Combo-Box (Combo1) is currently feeded by the following table:
01 - Category A
02 - Category B
Combo-Box (Combo2) is currently feeded by the following table:
01 - Product A
02 - Product B
What I would like to do is to have the second Combo-Box (Combo2) to be automatically updated depending on the values selected on Combo1.
So, If I select Category A on Combo1 I want to have the correspondent Product A on Combo2 and If I select Category B on Combo1 I want to have Product B on Combo2. I have tried some functions but I couldn't get the job done.
I have two fields both are combo boxes.
the first combo box sets the high level value. the second is based on a query that filters from the high level value and re-queries the form.
my problem is the second combo box brings backs the correct values but is un-selectable