ComboBox

[Brook]

I have a Combobox on my form that the has three fields in
it: In-Transit, Warehouse, and Consignment. What I am try
to do is that when the user chooses the "Consignment"
option some type of pop-up form will come up, which will
require the user to choose the Company Name from a
DropDown/Combo Box from my tblClientList. Once the user
chooses the correct client, they can click yes to continue
or NO to cancel.

Does anyone have any ideas on how to accomplish this? I
have an idea but can't figure out to translate it into the
coding.

Thanks,

Brook

 

[Alphonse Giambrone]

Brooke,

I am assuming that when you say your combo has 3 fields in it, you really
mean that it has three items (choices).

In the after update event of the combo:

If nz(Me!yourcombo,"") = "Consignment" Then
DoCmd.OpenForm "yourformname", acNormal, , , acFormAdd, acDialog
End If

On your form, have the combo with the company list for user to choose and
the two buttons.
Have the 'yes' button validate that a company was selected and then perform
whatever action you desire with the selected company and close the form. No
button should just close the form.

HTH

 

[Guest]

Thank you very much for the help!

This worked! I do have one other question though. When I
have my form opened to choose my Client for the
Consignment, Can I have that client name saved to a field
in my form?

Brook

Also, What does the nz coding mean?

 

[Alphonse Giambrone]

After your yes button validates the input add the code
Forms!yourotherform!yourdesiredcontrol = Me!companycombo

As for Nz, it is a very useful Access function that will replace a null with
whatever you want.
Look it up in help for more detail.

 

[Brook]

Thank you for the help!

I do have one other question, when my pop-up form comes
up for me to choose my Company from the drop down box, can
I have this saved to a field / table?

Thanks,

Brook

P.S. What does the nz stand for in the coding ?

 

[Brook]

When you say "Yes" button, are you just refering to
a "Yes" Command Button?

Brook

 

[Alphonse Giambrone]

Yes, the button on your popup form that will validate the user's selection
and then close the popup form.