I have tried a few options but keep getting this: :banghead:
I have a form for entering service information. But there is one service slightly different than the others, so I created a different form. My struggle is getting this second form to automatically show this specific service in the form field.
The closest I've come is using a combo box and basing the row source off a query which only returns the one service. So you can only select that specific service. But I would rather it just be a locked text box that displays the value (the specific service) any time I go to a new a record on the form.
I have tried using the "Default Value" field in the form properties, using SQL statement to return the value, and using DLoookup to return the value. I thought I could do it with DLookup, but: :banghead:
I have a form for entering service information. But there is one service slightly different than the others, so I created a different form. My struggle is getting this second form to automatically show this specific service in the form field.
The closest I've come is using a combo box and basing the row source off a query which only returns the one service. So you can only select that specific service. But I would rather it just be a locked text box that displays the value (the specific service) any time I go to a new a record on the form.
I have tried using the "Default Value" field in the form properties, using SQL statement to return the value, and using DLoookup to return the value. I thought I could do it with DLookup, but: :banghead: