Dropdown Query saved to Table

R

rjvega

Within my database, there is a table called Property_Numbers which stores
available property numbers and has a Yes/No box which identifies if the
number is assigned or not. There are currently three types of property,
"Company", "Customer", or "Open".

I have a form called "New_Stencil" which contains an unbound dropdown box
called "Property_Type". Currently, when the property type is selected, it
autopopulates a text box called "Property_Number" with the next available
number depending on the type. I did this by having the Row Source of the
"Property_Type" dropdown run a query and having the Control Source of the
"Property_Number" box equal to =Property_Type.column(2). It works great.

The "New_Stencil" form is bound to a table called "Data" and I want all the
information on the form to be saved there. The problem is that the Control
Source of the Property_Number box is already being used, so I can't link it
to the "Data" table. In other words, once the dropdown selection is made, I
need to have the number that comes up in the Property_Number box saved to the
Data table and at the same time, check off the Yes/No field in the Property
table.
 
Top