Issues opening a specific Record

[baxton]

Hey Everyone


Its been a while using access, trying to make an estimating DB for my Co.
Hope you guys can help, I'm having issues opening a specific record from a list of customer projects. I think it something to do with the relationship but I'm not sure

quick run down
*main menu
new customers btn opens form for new customers
Customers btn - opens all customers and I can open a specific customer from here.

*customer - shows customer details
create project btn - opens up to a new project creation
customer project - shows all current customers projects - from here I'm trying to open the customers project, it opens the correct form but its not showing the information, keeps going to a new record.

I think I have something missing but not sure what
ill drop the db. here

kind regards
Baxton

MJWI_Est_Invoicing_ver02.zip

[Welshgasman]

So show the code for the open form.
Walk through your code and inspect the variables/ control values.
If the form cannot find the record, that will happen. If data entry is yes, that will also happen.

[mike60smart]

Hi Baxton

In Design View Properties of your Form "ProjectF"
Select the Data Tab
Then set Data Entry to No vice Yes

[baxton]

ahhhh for god sake was that it? its worked thanks gents, i totally missed that.

[mike60smart]

We were glad to help