when date = set date display welcome

[murray83]

this is the code

'shows welcome msg
If Me.txtWelcomeDate.Value = "04/07/2017" Then
MsgBox "Happy July 4th" & Me.txtUserLookup.Value
Else
MsgBox "Welcome" & Me.txtUserLookup.Value
End If

and it works fine apart for one thing it doesnet say the persons name which it gets from the txtuserlookup
any dieas on what i have done wrong

 

[Ranman256]

1. You don't need the .value,
MsgBox "Welcome" & Me.txtUserLookup
Should work IF there is a value in the box.

2. This "ME.control" works only inside a form, not in a query,nor module outside a form.

 

[murray83]

cheers will try that

 

[murray83]

well i did that and this is all i got ( see attached image )

this is still my code

'shows welcome msg
If Me.txtWelcomeDate.Value = "04/07/2017" Then
MsgBox "Happy July 4th" & Me.txtUserLookup
Else
MsgBox "Welcome" & Me.txtUserLookup
End If

 

[Minty]

Is your user lookup control definitely called txtUserLookup?

 

[Gasman]

Try MsgBox Me.txtUserlookup and see what that shows you?

Do you have Option Explicit in your code modules?

 

[murray83]

Try MsgBox Me.txtUserlookup and see what that shows you?

Do you have Option Explicit in your code modules?

yes that worked it displayed my name

and yes it is called txtuserlookup see attached

 

[Minty]

Where is the code run from - which event?
Your control's value is set using a Dlookup() that probably won't have run at form load, and is therefore still blank when you call the message box.

Have a read here about what fires and when https://support.office.com/en-us/ar...ce86553682f9?ui=en-US&rs=en-US&ad=US&fromAR=1

You probably need to run it from Form_Current event to make it work.

 

[Gasman]

So you placed that MsgBox Me.txtUserLookUp with the rest of your code in the same place?
I'd be putting a breakpoint at the if statement and ? the variables.

yes that worked it displayed my name

and yes it is called txtuserlookup see attached

 

[murray83]

break point would that be this

Stop

 

[murray83]

Where is the code run from - which event?
Your control's value is set using a Dlookup() that probably won't have run at form load, and is therefore still blank when you call the message box.

Have a read here about what fires and when https://support.office.com/en-us/ar...ce86553682f9?ui=en-US&rs=en-US&ad=US&fromAR=1

You probably need to run it from Form_Current event to make it work.

yes thanks form_current works a charm

 

[Gasman]

I just click with the mouse and put a breakpoint on a line,(marked with a red dot) then clear it or all when done.