If Username in your query gets its value from getusername() is it actually a field in a table. Have a look in your modules for this function. What is it doing?
Quote:
Originally Posted by davidmarks
I am trying to use a combo box to set a variable, and then refresh the form using that variable when the combo box is changed. I've used the following method before, but must be forgetting something else I need to do. What is it.
THe combo box has the following when it is changed
Private Sub Combo43_Change()
Userrname = Me.Combo43.Text
DoCmd.Close
DoCmd.OpenForm "Entry 2"
Exit_Combo43_Change:
Exit Sub
When i run it i get a message which says 'undefined function getuserrname in expression.
What do I need to do?
In the query, the column I want to use the value in is
getuserrname()
