Subforms on form

[teza2k06]

The database i have created has a large subform on it, which is a table for me to enter in information for that record, but im having problems with it.


When i open the form i add data to the form and subform, but when i click the button for a new record it makes a new one and clears the writing so i can fill out the new record. But it does not do it for the subform..


How can i do it so that when i click new record it will clear the data on the form and subform, so that when i switch through the records then the data will change showing the correct information in the subform??

[TG_W]

try adding Me.Refresh or Me.Requery to the code for the button.