Form opening blank

[kernowboy]

Hi,

Could someone help please.

I have a form frmcustomer, that has a subform in it tbljob subform, that is view only.

I have added a button to "create new job" which closes the frmcustomer and opens frmjob, so that I can add a new job to that customers list.

However when I click the button, the frmcustomer closes and the frmjob opens, but it is completely blank, no field boxes or anything.

When I open the frmjob normally from the navigation pane it opens fine.

Any ideas?

Thanks

Ali

 

[McSwifty]

it sounds like there is something not quite right with an underlying query.
ihave seen this in one of my early versions of a work DB.

can you post a copy of your DB?
Include which version you are running too as it may have an impact on possible help that can be given.

 

[kernowboy]

Hi Kev,

Thanks for your reply, here's a copy of the database attached, I'm using Access 2010.

Also, another problem I have is when starting to enter data into the frmcustomer, I get the message up "Access cannot apply the filter because all of the records are locked", I have looked in the form properties and made sure all records are not locked, but this doesn't seem to make a difference.

Thanks to anyone in advance.

Ali

 

[McSwifty]

hey,

thanks for posting the DB, i cannot help as I don't have A2010- sorry.

As for the locking of records, the form should be set to only lock the current record and not all records. if all records are showing as locked is the table/query already open somewhere elsewhen you open that form?

 

[kernowboy]

Hi Kev,

Thanks for your fast reply, however, I've literally just managed to solve both of these problems with one action. The sub-form I had in the customers table was locked so this was causing the filter error message and the blank form problem.

Many thanks