Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem linking forms

Status
Not open for further replies.

Fibee

Programmer
Jul 26, 2002
39
GB
Hi
I have a form which contains a persons details and have added a subform. This subform just contains a combo box with a list of venues and 5 date fields - each venue only has 5 dates so when you change the venue the dates change appropriately. This subform works fine independently and the dates change like they should, when I add this subform to the main form however as soon as I change the value on the combo box I get 'No Current Record'. The vba code that it highlights is as follows:

Me.RecordsetClone.FindFirst "[VenueID] = " & Me!Combo13]
Me.Bookmark = Me.RecordsetClone.Bookmark

I have a feeling its to do with the fact that the two linked fields are both empty when you first create a new record. I have tried to set the combo index to 0 but it doesn't work! The two forms are linked via VenueID. The idea is that when a venue is selected the person can decide which dates he wants to go on or on all 5, he can also attend more than one venue. Hope this all makes sense.
Any help would be appreciated.

Thanks

Fi



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top