Form cannot see all records (1 Viewer)

[Les Simpson]

Hi All

I have created a tabbed main form in Access 2007. Fifty records are already in Datasheet view but only the First record can be read in the Form.

I have no filters set. The record selector shows 1 of 1 with a data fully visable correct first record. If scrolled right records 2 of 2 shows but the form is blank. No other records are visible.

Any help appreciated to see all records on the Form.

Les

 

[vbaInet]

Are you sure this form isn't a subform?

 

[Les Simpson]

Uncertain about that VBA. I created a blank form then added a 5 Tabs form straightaway. Then added field controls.

I would not of considered this a subform; but may be wrong.

Thanks for your interest and reply.

Les

BTW I created an auto form that worked correctly before striking out on my own form design.

 

[vbaInet]

Upload a stripped down version of your db and let's have a quick look.

 

[Les Simpson]

On my way to a meeting now VBA. Will upload database file, as is, later this evening.

All the best

Les

 

[vbaInet]

No worries Les.

 

[Les Simpson]

Here is the problem File VBA with some data. I still have to do some normalisation and form design.

Many thanks for your kindness in offering to help me out of the chasm.

Les

 

[amunafc]

can you pliz upload it as an Access 2003 version?

 

[vbaInet]

Here we go. You needed to change the join.