Linking 2 Listboxs to a New Form in Access

By p_monteverde ·
I'm developing a form in access, that auto fills information that is not relevant to store, but is really usefull to see, for users who are filling the relevant information of the form.
Using the Dlookup function i have managed to fill the information that i want users to see. But all this information is based on primarily 2 key fields (in this case "RUT" and "CodEv") that must obviously be filled before the dlookup function works.
My problem is that I created another Form (Menu) containing 2 listboxs, that show the information related to "Rut" in the first, and "CodEv" in the second, and I want to create a button that opens me a new form to fill, and automatically copies to it the "Rut" and "CodEv" selected by the user, so all the fields that are linked to this values can automatically be filled up.

I think this is a really basic question, but i'm a really new user to access and its programing codes in VBA, so any help will be welcomed.

Thanks to all,
Pablo (Chile).

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums