Search results

That sounds ideal, but could you help me further by telling me how to link the data in the combo boxes to what is shown on the subform ? Many thanks once again.

Could anyone tell me if it is possible to use data from a combination of a combo box and two text boxes to show data relating to that data from a table? I have a table named COURSE which holds course information (Title, Location, Date etc.) and would like to search this table using the data...

Sorry :-(

Although I have posted a question on this topic before, I have yet to get a satisfactory answer - so hopefully this time one of you wizards can sort me out . . . I have a table called COURSE SCHEDULE which has a attribute called NUMBER OF PLACES on it. I would like to some how create a query...

Thanks for the good advice. Have already managed how to get a count of people on courses - it's how to subtract that value from original "how many places". No can do - yet!

Don't quite get it? - what is count, Dcount?

Thanks to all who have helped me enormously so far, here's another little problemo... I have a COURSE table with an attribute of NUMBER OF PLACES for various courses on it. I would like this number to be decreased by one each time a booking is made (through a BOOKING form) for a particular...

I've just read a message on the forum showing me how to do it exactly, namely Me.Combo20 = Me.Text18.Column(2). Thanks ever so much for your help anyway; can you tell me (sic) what 'Me' actually does?

I have tried using AfterUpdate [Text10] = [Combo8].Column(1) but it completely refuses to update automatically. Is there something obvious I am missing ???

I know I shouldn't really ask two questions so close together but . . . I have got a form called EDIT CUSTOMER DETAILS which is linked to a CUSTOMER table. Is it possible to have a button that clears the form a data and makes it ready for a new customers data to be entered? One of the fields...

I am trying to create a text box ('Location') that updates its contents after an option is chosen from a combo box (a list of different courses) on the same form. When I choose a particular course, I want the text box to display the town related to that particular course. I can create a combo...

I am trying to create a form ('Make A Booking') which will allow me to update a table with the information I type into it. The data is about numerous customers (e.g. name, address etc.) but I can't work out how to link the customer table and the 'Make A Booking' form. Can anyone help? ? ?