Blank Form

[kevin19]

When a query returns no records, the form appears blank.
how can I make the form appear eventhough there are no records to show prior to inputting data.
I have searched the forum but to no avail of what I need to do.

Anyone please???

 

[RuralGuy]

Try setting AllowAdditions true.

 

[kevin19]

Hi Guy!

thanks for your response. AllowAdditions was set to Yes previously. I am still facing the problem....Can't think of anything else at present.

 

[David R]

Have you verified that when records DO show up, you can make additions?

Sounds like your recordsource for the query is not updateable.

 

[kevin19]

Thanks David for your quick response....
The query actually returns calculated fields that are not updateable. But isnt there a way to make a form appears even there are no records. I have tried setting the calculated fields default value to 0 but this doesn't work either.
Mind boggling!!! surely there must be a way... I am not and Access expert. Learning and improving. Need to consult you experts!!

 

[David R]

I'm about to go, but my first thought would be to calculate those values on the form (via unbound fields) and not in the recordsource... then it's much more likely that your form remains editable, and you can put those calculations into a report-only recordsource that doesn't need to be editable... make sense?