Records do not show in a form

[Andy Dorph]

I have created a form which is called from a menu. There are two ways to
call the form. The first does not show the navigation bar. The second shows
the navigation bar.

My problem is:

When I call for the form and have it display the navigation bar, it acts as
if there is no data in the data source table. There is. I checked.

What do I need to do to get the data to show on the form. I am allowing
form and worksheet view in the form properties.

TIA

 

[Allen Browne]

Make sure the form's Data Entry property is set to No.

When you call the form programmatically, open in edit mode, not add mode.
For example, this line would open Form1 with NO records displayed:
DoCmd.OpenForm "Form1",,,,acFormAdd

 

[Andy Dorph]

That did it. Thank you!

Make sure the form's Data Entry property is set to No.

When you call the form programmatically, open in edit mode, not add mode.
For example, this line would open Form1 with NO records displayed:
DoCmd.OpenForm "Form1",,,,acFormAdd