Default Value In a Control

[AccessTexas]

I have an inventory entry form with 3 controls on it. One is the area counted, the second is an item number, and the third is the amount counted. When the form is opened it prompts for the area counted which then changes the default value so you don't have to enter it again. The problem is that it works for a number but not alpha-numberic or alpha.

The table is set as text and I've tried setting the inputbox to string and still can't seem to avoid the #Name? error.

Any direction would be appreciated. I tried looking up a past thread but couldn't find anything this specific.

 

[pbaldy]

It would have helped if you'd posted your code, but if you have something that works for a number and not text, it's probably a situation that requires single quotes around the text value.

 

[AccessTexas]

Sorry about the code missing. What you said was right on the mark though. I changed the inputbox to take the typed in value sandwiched between the single quotes and it works as intended. Thanks for your help.