Refreshing records

[Rob.Mills]

I have two subforms that are related. The first one is a datasheet showing all the records and the other is a single form showing more detail. What I'm trying to do is when the user modifies a record in the single form then have those changes propogate to the datasheet. I've tried using the refresh command but to no avail.

Any ideas?

 

[Rob.Mills]

Well no, neither of them can add records.

I tried using the command you gave me and got an error saying 'Object doesn't support this method.'

I also tried Forms!MainForm!Subform.Form.Refresh. Didn't get an error but it also didn't work.