Want form to Open displaying specific data

[Laura]

Wonder if you can help me regrding the relationships in my Database which I think are affecting my forms.

I have a table with a primary key called customerID and 2 foreign keys called acting and not acting. Therefore, as the information is stored, a customer has either an acting or not acting number - but not both. And the ones which are ongoing have neither.

the problem I have is when trying to input information through a form. I am basically using a search to find the correct customer then on choosing this customer I am using a command button to open the correct form (using a condition CustID=CustId). Anyway this works fine for just displaying the current information, but if I cannot input any new info, not sure why.

The form just comes up blank, with CustID just saying [autonumber]. If I type in the ID then, yes, it does bring up the info - but I want it to open with the info ready. What am i doing wrong?

 

[Robert Saye]

Hello,

Easy fix, I had this problem too. Go to design view for your form and look at the properties for your form. On the data tab, set "Data Entry" to no. This doesn't prevent you from entering new data, it just is saying this is not an exclusive data entry form.

HTH

Robert