Combo box value link

  • Thread starter Thread starter Juli
  • Start date Start date
J

Juli

I have a database that I am using for Library Inventory.

I have created a main input form with only 2 inputs. The
second input is a combo box with a defined list. I have
created specialized input forms for each of the values in
the combo box list.

I would like to have the correct input form open when
it's associated value is selected from the list.

I have not quite figured out how to do this. Any help
would be greatly appreciated.
 
Hi,
You would use DoCmd.OpenForm in the AfterUpdate event of your combo.
It would be really easy if the forms were named the same as your values.

You then could just write:
DoCmd.OpenForm Me.yourCombo

Otherwise you would need a select case statement:

Select Case Me.yourCombo
Case "someValue"
DoCmd.OpenForm "someform"
Case "someothervalue"
DoCmd.OpenForm "someotherform"
End Select

I'm also assuming you only have one column in the combo.
 
I really hate to be such a newbie but I need a little bit
more assistance please. My forms just happen to be named
the same as the values in my list.

Now is this a macro that I am creating? and do I need to
create a seperate one for each value/form combo?.

I am a bit lost. I tried the statement just as you wrote
and got an error message.

Thanks again.
 
Hi,
It's not a macro, it's VBA code.
You would place the line:
DoCmd.OpenForm Me.yourCombo
in the After Update event of the combo.

In the combo's property sheet on the Events tab,
place your cursor in the After Update event.
select [Event Procedure] in the drop down that appears.
Then click the elipsis (...).
The code editor will open.
Copy and paste the above line.
You will have to substitute the real name of the combo in place of
yourCombo
 
Thank you!!!! Thank you!!!! Thank you!!!!

That was exactly what I wanted.

I can figure out most of the simple stuff on my own, but
I still need a bit of help with some of the other stuff.

I truly appreciate your assistance.

Juli
-----Original Message-----
Hi,
It's not a macro, it's VBA code.
You would place the line:
DoCmd.OpenForm Me.yourCombo
in the After Update event of the combo.

In the combo's property sheet on the Events tab,
place your cursor in the After Update event.
select [Event Procedure] in the drop down that appears.
Then click the elipsis (...).
The code editor will open.
Copy and paste the above line.
You will have to substitute the real name of the combo in place of
yourCombo


--
HTH
Dan Artuso, Access MVP


I really hate to be such a newbie but I need a little bit
more assistance please. My forms just happen to be named
the same as the values in my list.

Now is this a macro that I am creating? and do I need to
create a seperate one for each value/form combo?.

I am a bit lost. I tried the statement just as you wrote
and got an error message.

Thanks again.

of
your combo. same
as your values. values
in
Click to expand...


.
Click to expand...
 
You're very welcome :-)

--
HTH
Dan Artuso, Access MVP


Thank you!!!! Thank you!!!! Thank you!!!!

That was exactly what I wanted.

I can figure out most of the simple stuff on my own, but
I still need a bit of help with some of the other stuff.

I truly appreciate your assistance.

Juli
-----Original Message-----
Hi,
It's not a macro, it's VBA code.
You would place the line:
DoCmd.OpenForm Me.yourCombo
in the After Update event of the combo.

In the combo's property sheet on the Events tab,
place your cursor in the After Update event.
select [Event Procedure] in the drop down that appears.
Then click the elipsis (...).
The code editor will open.
Copy and paste the above line.
You will have to substitute the real name of the combo in place of
yourCombo


--
HTH
Dan Artuso, Access MVP


I really hate to be such a newbie but I need a little bit
more assistance please. My forms just happen to be named
the same as the values in my list.

Now is this a macro that I am creating? and do I need to
create a seperate one for each value/form combo?.

I am a bit lost. I tried the statement just as you wrote
and got an error message.

Thanks again.


-----Original Message-----
Hi,
You would use DoCmd.OpenForm in the AfterUpdate event of
your combo.
It would be really easy if the forms were named the same
as your values.

You then could just write:
DoCmd.OpenForm Me.yourCombo

Otherwise you would need a select case statement:

Select Case Me.yourCombo
Case "someValue"
DoCmd.OpenForm "someform"
Case "someothervalue"
DoCmd.OpenForm "someotherform"
End Select

I'm also assuming you only have one column in the combo.


--
HTH
Dan Artuso, Access MVP


I have a database that I am using for Library
Inventory.

I have created a main input form with only 2 inputs.
The
second input is a combo box with a defined list. I
have
created specialized input forms for each of the values
in
the combo box list.

I would like to have the correct input form open when
it's associated value is selected from the list.

I have not quite figured out how to do this. Any help
would be greatly appreciated.


.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top