okay.... here is the code:
Private Sub Command168_Click()
houselogsrchtbl.date = date
houselogsrchtbl.staff = currentuser
houselogsrchtbl.logentry = log_enter
log_display = " " & Now & " " & currentuser & vbCrLf & log_enter & vbCrLf & log_display
log_enter = Null
End Sub
What I want this to do is enter the information in 2 spots. The houselogsrchtbl.*'s are on the next page (seperated with a page break) log_display and log_enter are on the current page (same as the command button). the form is based on a qry that links the two tables together so that when a log entry is complete, the user will click the done botton and the entry will add to a memo field so thet is is viewable right on the screen as well as in an independant record in a linked table (page 2 of the form)so that the entries are searchable.
does this make sence???
god I hope so!
help please
Private Sub Command168_Click()
houselogsrchtbl.date = date
houselogsrchtbl.staff = currentuser
houselogsrchtbl.logentry = log_enter
log_display = " " & Now & " " & currentuser & vbCrLf & log_enter & vbCrLf & log_display
log_enter = Null
End Sub
What I want this to do is enter the information in 2 spots. The houselogsrchtbl.*'s are on the next page (seperated with a page break) log_display and log_enter are on the current page (same as the command button). the form is based on a qry that links the two tables together so that when a log entry is complete, the user will click the done botton and the entry will add to a memo field so thet is is viewable right on the screen as well as in an independant record in a linked table (page 2 of the form)so that the entries are searchable.
does this make sence???
god I hope so!
help please
