Forms is loaded function

X

XRAIVE

Hi All,

I currently have the current setup

TravelForm

TripsForm

TripEventsForm

When a user fills out the the travel form and wants to add trips to that
record they press the Addbuttton. The trips form references the specific
record using the IsLoaded Function. On the OnActivate propery of the Trips
form I have the following code

If IsLoaded("TravelForm") Then
If Forms![TravelForm]![TravelForm Subform].Form.RecordsetClone.
RecordCount > 0 Then
DoCmd.GoToControl "TripID"
DoCmd.FindRecord Forms![TravelForm]![TravelForm Subform].Form!
[TripID]
End If
End If

Now I did the same setup for the TripEventsForm when a user wants to add an
event for each trip.

I keep getting an error "DoCmd.FindRecord Forms![TravelForm]![TravelForm
Subform].Form![TripID]" stating that this is the problem
 
J

June7 via AccessMonster.com

This is a duplicate thread.
Hi All,

I currently have the current setup

TravelForm

TripsForm

TripEventsForm

When a user fills out the the travel form and wants to add trips to that
record they press the Addbuttton. The trips form references the specific
record using the IsLoaded Function. On the OnActivate propery of the Trips
form I have the following code

If IsLoaded("TravelForm") Then
If Forms![TravelForm]![TravelForm Subform].Form.RecordsetClone.
RecordCount > 0 Then
DoCmd.GoToControl "TripID"
DoCmd.FindRecord Forms![TravelForm]![TravelForm Subform].Form!
[TripID]
End If
End If

Now I did the same setup for the TripEventsForm when a user wants to add an
event for each trip.

I keep getting an error "DoCmd.FindRecord Forms![TravelForm]![TravelForm
Subform].Form![TripID]" stating that this is the problem
Click to expand...
 
Top