Forum Discussion
Fill in table fields automatically from dropdown selection
Hello,
I found quite easily how to fill in fields from a Combo box in a form, but I can't seem to do the same in a table. I would simply like fields in my table to be filled in automatically following a selection from a dropdown list of an external table with several columns (fields).
See attached image.
thanks
seb
You could do this with a data macro in the concerning table. For instance a Before Change data macro that uses the LookUpRecord and the SetField actions to get and fill the appropriate values. This link should get you started: https://support.microsoft.com/en-us/office/create-a-data-macro-b1b94bca-4f17-47ad-a66d-f296ef834200
- Thanks Tieme. I'll will look into it.
- Data entry should always be done through a form where you can easily setup such features and validate data entry properly. One should never be exposing tables directly to users, doing so is asking for problems. I'd strongly urge you to reconsider.
HI Daniel,
If for exemple I have a Time sheet form with Date, Shift (AM/PM) and supervisor name as fields. And I have a subform for entering employees for the shift with only dropdowns and checkbox. Would this be ok or you would still suggest to go with form fields?
Also, if I go with form fields for entering the employee, does it mean I have to create a limited amount of lines to enter employees? And will I be able to use the Count function to get how many employees were booked on the shift?
