Error checking

[Me.Howard]

I have a text box on a form into which I manually input a job number. It is imperitive this be a valid job number. I have a table of all valid job numbers. I have created a query from this job table which returns a valid matching job number from the job table. This works fine. I am trying to compare the text box job number to the returned job number from the query. My thought was to put the query returned number in a variable . Dim SaveValue as Integer. I haven't figured out how to put the query job number in the SaveValue variable. My purpose for doing this is to show message if they do not match. The query woks fine just not the move to the variable.

Is there a better way to accomplish this?

Any thoughts will help.

[ItsMe]

Maybe you can use a combobox's Rowsource to retrieve a list of valid Job Numbers. Then, the user can select an option form the list provided by the combobox control.

[Me.Howard]

T^hats the way I have it functioning today. I am just trying to clean it up while I continue to learn.

[Me.Howard]

I have also used the Dlook for the Job name looking in the job table. I have a problem here in checking the JobName text box for a blank. The text box contains #Name? and I cant check for that either.

[Me.Howard]

The combo box approach is working. Guess I'll let it go with that.

Thanks

[ItsMe]

...The text box contains #Name? and I cant check for that either.

This is likely associated with that text box control's Control Source property. If you want to bind it to a field, select an option from the Control Source property's pull-down.

As for the combobox thing, the combo and the listbox are the go-to controls when you need to provide additional recordsets. If there is only one option you want to provide (a value for a simple data type), you can store that in a variable and or assign the value to an unbound control in another form. In other words, if the user does not have to choose a value, assign the desired value to something like a control and or a variable.

[Me.Howard]

Thanks Its Me, You have been a big help.