Recent content by tdezwaan

Ron Thanks for the idea. I did what you suggested (using code described in thread702-24405, actually). Though a new record was added, I was still unable to paste multiple records into the datasheet view of the subform. Again, I can add the records one at a time and the appropriate...

I have a subform in datasheet view that I need to copy and paste multiple records into from an excel spreadsheet. The pasted data goes to a table that has an autonumber field as the primary key. I want to change the autonumber field to one that enters values incrementally based on VBA code to...

I have two tables in a one-to-many relationship. In one of the fields on the child table I found that the data in two records was changed to "?/". When I query the data these records are still related to the correct records in the parent table. When I try to change "?/&quot...

Thanks very much! Setting the visible property to no in the main form's On Activate or On Load worked. When I set the visible property to no in On Got Focus, the subform was visible when I opened the main form though (?). tdezwaan

I have two command buttons that I am using to open and close a subform. To open the subform in the main form I am using the code: Private Sub OpenSubform_Click() Me![SubformName].Form.Visible = True End Sub To close the subform in the main form I am using the code: Private Sub...