Could someone look at the prob with form on this DB?

[dragginthru]

My combo box problem is still at large!

I've tried every way i can, and i cant get the rowsource query right.

If someone could look at this and post a fix, so that when one uses the "training record" form it allows you only to select course dates that are already in the tbl_course_dates table.

Thanks so much

http://www.suicidenotesmusic.net/nonworkingcombos.mdb

 

[dragginthru]

Sorry to keep bumping this one, I wondered if anyone could pleeeeeeeeeeeeeeeeeeease help me coz this is a major hurdle that I need to get past to carry on

 

[CEH]

simple dropdown?

Are you trying to do just a simple dropdown in the combp box? Like attached?

 

[dragginthru]

Are you trying to do just a simple dropdown in the combp box? Like attached?

Thanks for having a look

Basically (not included) is a seperate form which writes to the training_courses table (ie. user inputs the title, cost etc) and there is a subform which the user can enter dates for the course. This is how the [Training Courses] and [tbl_course_dates] are populated in the first instance.

A seperate form, [Training Record] sits as a subform in a main form which has an employees details. It works OK at present, with just box A (course title) being a combo, and box B just being a text box. OK so we have a way to get the data in. BUT the point is so that the 2nd box will only make available for selection dates that have been input for a course, which stops a user signing someone up for a non-existent date!

The example you put for some reason wont let you select different values in box A, and the 2nd box shows ALL the records (course dates) - i.e. is not dependent on user selection and hence only the relevant dates.

That make sense...?

 

[CEH]

well.....................

Well, someone with more experience then I should be able to get this one pretty quickly... But a couple of questions come to mind.... Why is "Course date" in mutiple tables? IS there a reason for having a table for "Training course" AND "training record"???
Looks like it should be a matter of a simple SQL statement once the tables are in line.... Using the "CourseID" text box in the form to fill your WHERE clause in the statement, filtering the available dates. But then someone may be able to give you a line of code that is even easier
Like I said... Lots of very experienced people here who can answer this one better and quicker then I can.

 

[dragginthru]

I think there is a purpose to all tables...

The example I posted only has the offending tables and forms in it. The table "training record" is actually written to by the training record form as a subform which is within a form for staff details. So a member of staff can be added to the course and the training record shows who did what course when basically.

THanks for taking a look!