Continuous Forms

[smash54]

I have a form with a command button with on click:
Private Sub Command6_Click()
Dim ID As String
Dim TT As String 'tt=time
Dim DD As Date 'dd=date
TT = Time()
DD = Date
ID = fosUserName()
Forms![frmMain]![Child9].Form![Hash] = ID
Forms![frmMain]![Child9].Form![Date] = DD
Forms![frmMain]![Child9].Form![Time] = TT
Forms![frmMain]![Child9].Form![Sent] = -1


but my child form is a Continuous Forms and I cant get it to go to next record without clicking on the child form. It will only refresh the first record from when I clicked the command button.

 

[Guus2005]

a continuous form is typically used to display data from a query or table.
instead of directly setting the values of controls on the subform, you should add a record to the table or query to which the subform was bound and requery the dataset of the subform thus refreshing the data on that subform.

Enjoy!

 

[smash54]

Ok so I was rethinking this what would be the easy way to have this info go straight to a table. Then I can use a query to get the info back from the table.

 

[Guus2005]

if you are using a bound subform, all data entered is directly stored in the database table.

HTH