Solved Comvo box checking value from one form to main form (1 Viewer)

[lacampeona]

Hello experts I need some ideas how to make something:

I have two forms. Form A and form B.

On form A I have text box that contains value house.
On form B I have combo box that has some values inside. Value1, Value2, Value3.

Now I need some ideas how to resolve that:

User can choose Value3 from form B only if the text box from form A contains value House. The text box from form A cant be empty.


If the text box from form A is empty I need some message to say to the user that he cant choose Value3 becouse text box is empty.
I need to prevent choosing combo Value3 from form B if text box from form A is empty
hmmm

is possible to make something like that? hmmm
thanks in advance

 

[CJ_London]

perfectly possible - in form B open event (or some other depending on how your app works)

select case nz(forms!formA!textbox,"") 
    case ""
        msgbox "complete textbox in formA"
    case "house"
        combo="value3"
        combo.enabled=false
    case else
         combo.enabled=true
end select

 

[lacampeona]

hello
hmm i trying on open but it not ok ? maybe i m doing something wrong
Can I put this on the combo box? hmmmm
if user choose value3 then ithis message show up?
hhmm

 

[lacampeona]

helloo
yessss i made it is working. i also put that after msg box open formA so the user can enter the value
thank you very much