Search results

All the course details are already entered, so the search just finds the correct record and populates the fields accordingly. I've managed to get this done with a macro, doesn't seem like the best method but appears to work.

I'm creating a booking system for course and I'm using the following code to reduce the places available by 1 when someone else is booked on a course: SearchID = intCourseDetails DoCmd.OpenForm "frmCourseDetails" DoCmd.GoToControl "intCourseDetails" DoCmd.FindRecord SearchID...

I'm using the code Forms!frmMainBooking!frmBooking.Form!intCourseDetails = [intCourseDetails] to copy an integer from one subform to another. It works fine but I'm not sure how to initiate it. I've got 3 subforms, in 1 the user selects a course from a drop down box, this loads another form...

Thanks, works perfectly!

Is there any way of starting with a new record when a form is opened rather than record number 1?

Is it possible to apply an image to the background of a form or object in a form (such as a rectangle) rather than just a solid colour? If so, how?

Sorted, thanks KeithG, didn't realise the name of the property could be different to the name of the subform.

If I access the subform directly and change the query to [Forms]![Course Subform]![Combo12] it works fine, the problem only exists in the subform!

I'm still just getting the 'Enter Parameter Value' popup box :confused:

I get the 'Enter Parameter Value' popup box as if no search criteria were supplied. I tested the subform function as a mainform (obviously droping the mainform from the query) and it works fine, just not as a subform which is why I believe there is a small problem with my query.

Hi, I'm having some issues querying a sub form. I'm using a combobox (in a subform) which supplies some search criteria. I'm using the query Like [Forms]![Employee]![Course Subform].[Form].[Combo12] & "*" but its simply not working. Can anyone see any glaringly obvious mistakes?