J
Jeff
I am creating a form in Access that I'm using to edit a table named
'Quantities'. I have created a separate table, named 'Projects', that
contains 2 columns: Project Number & Project Name. I would like to
create two comboboxes that have this behavior: If I know the project
name, the project number is automatically entered into the other box,
and vice-versa.
I also will then need the project name and number that is displayed in
these boxes to be entered into their respective fields in the current
record in the database that I'm editing. I don't know if this is too
much to ask of access, as I'm still learning how to use it. I would
be happy if the project name combobox updated the project number box,
as I rarely remember the numbers anyways.
Thanks in Advance
'Quantities'. I have created a separate table, named 'Projects', that
contains 2 columns: Project Number & Project Name. I would like to
create two comboboxes that have this behavior: If I know the project
name, the project number is automatically entered into the other box,
and vice-versa.
I also will then need the project name and number that is displayed in
these boxes to be entered into their respective fields in the current
record in the database that I'm editing. I don't know if this is too
much to ask of access, as I'm still learning how to use it. I would
be happy if the project name combobox updated the project number box,
as I rarely remember the numbers anyways.
Thanks in Advance