Recent content by erniejay

Problem solved!! By comparing the properties of other forms and subforms that worked properly, I found the solution. In the subform, the Data Entry property must be set to NO. If set to YES the record does not display. It is confusing but that's how Microsoft designed it.

Thanks for your reply. To answer your questions: No code is used. Subform Properties shows correct linkage between master field and child field. No Events are listed in the Properties for either the form or subform. We can live with this with proper instruction to users but I found that users...

I have a form whose data source is a query that produces a subset of table 1. The subform's data source is table 2 and is linked to the form record by a common ID. When the form opens to its first record the subform is blank although there are corresponding records. If I scroll the form to the...

Thanks Bob. That was fast and righton the head. Thanks again.:)

My table with an autonumbered ID has started assigning numbers for new records that were already assigned to other records and these numbers are not higher than the highest previous number. It's like the autonumbering process has gone wild. Any ideas why this is happening and how to stop it? I'm...

I have an Access Database with a switchboard menu but the database window is hidden. When I press F11 to view the database window, it appears in the upper left part of the screen but only its lower half is visible. So there's no title bar to drag the window with and no min/max/close buttons. I...