Opening Form error

[rythem]

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

 

[Birdy]

Look at the query

there will be a prompt asking for the number.

Do you need to put the number in?

 

[rythem]

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.

 

[astarbyfar]

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.

 

[rythem]

hey thanks,

i did mess up there