Recent content by botsGuy

Sorry I don't think my question was ver clear. I have a list box on a form and when an item is selected in the list box, I take the values of one of the selected columns. When one of these Items is selected I need the subform to go to the record based on this variable.

Hi,I am wondering how to get a subform to automatically move to specific record. I thought I could just create a DAO recordset based on the subform and move through to record I want using FindFirst(condition). But I can't seem to create a recordset from a subform. Please Help, CHeers James

I tried doing three crosstab queries but I couldn't work out how to join them. The values on the outside are fixed eg monday tues day.., and 9.00am, 10.00am... But the vaules in the slot are fitness classes, the name of the classes instructor and the number of people currently enrolled in the...

Thanks, I had a go at this but the problem now is you can only put 1 value in each slot. I want three fields to be displayed. ANy Idea how I cold get around this. Cheers.

I want to create a timetable based on a table. It needs to have time on the vertical axis and day across the horizontal. The entries in the time table will be the record in the table which has the corresponding date and time. THe timetable sits inside another form, if possible I would like to be...

I have a member application form set for data entry based on member table recordset. Instead of saving records normally I want the user to be able to push a submit button and for the new informaiton to be entered into the table.It seems like it would be something trivial but I can't work it out...