Opening Form error

rythem

I.S Analyst
Local time
Today, 02:47
Joined
Mar 28, 2005
Messages
30
Hi

My repair form pulls data from the vendor table to display the vendor information.
Whenever i try to open the repair form, it gives me a popup first that says "enter the extention number"
regardless of entering data or pressing cancel my form gets displayed.

When i enter a number (a random number) it wil populate my extention field along with all other data. And when i dont enter any number and hit the cancel button, it populates all data except the extention field, that has nothing to do with the number that i enter but is the one stored in the vendor table.

I am confused what to do with this
Can anyone help me

thanks
 
Look at the query

there will be a prompt asking for the number.

Do you need to put the number in?
 
it does ask for a number but i dont want this pop up to appear.

actually even if i dont enter the number my form apears and populates with the vendor information. but it does not populate my vendor extention

if i do enter the number in the beginning (a random number has nothing to do with my vendor ext), it populates the ext field with the rest of the information.

i want to get rid of the popup that appears at the beginning.
 
Query

Im not too sure here but it sounds as if the forms source is from a query. If so go to the design of the query and check to see if the Criteria section has a prompt message. This may have been created by simply copying and pasting (Ive done it many times!). Hope this helps, if need be you could post the database so that I can have have a closer look.
 

Users who are viewing this thread

Back
Top Bottom