Stuck on Error trapping.. This might be easy for u programmers

[JesseL]

First of all: I created a query, and in the criteria in txtMrdNum, i have a parameter value that says [please enter the mrd number].

Ok.. I have two forms. One Main form that i want the user to add records only. To get to the Edit form, the user has to click on the cmdEdit form button, and a parameter value box prompts the user to enter the Mrd Number. They will know the number, so thats not a problem. I just want to error trap it if they enter in a bogus number, and i dont know how to do this.

Is there a easier way to do this besides this parameter value box? I was thinking a input box, but im not familiar with programming. Please help

 

[Darrylles]

Hi,

Leave work

Go to college and Uni on a software engineering course.

Lose £40-£50k earnngs, but you do learn!

Get back to work on half the money. LMAO in despair.

Regards : -(

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[JesseL]

I forgot to mention:

When the correct mrd unit number is entered into the parameters box, all records with that mrd unit number are shown. I have error traps on all text boxes that are not entered. If the user would type in a bogus number, the form would be blank.. Obviously because there are no records with that mrd unit number. I will show the code tommorow, im too tired right now

 

[Darrylles]

lol "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."

 

[jlitondo]

What you could do is create a switchboard or menu form with these two options, Add a new mrd number and Edit an existing mrd number.When your user clicks on the add button, you open your form in add mode setting its data entry option to true.
If your user selects the Edit button, then you open up the same form in edit mode by setting the data entry option to no.
On this form you will need to add a combo box linked to the mrdnumber field and set it to look up a value in your form. Open its properties and set its 'limit to list' option to yes. That way, users get to select only an mrd number that exists in the system and cannot type one in that is non existent.
Disable the combo box when your form is opened in add mode. jlitondo@gatecitysteel.com

 

[JesseL]

It's all copesetic now guys... thanks for being here!

ksharp