RecordSource help

[mann2x]

I am a new member in this forums,may you all support me well and i guarantee that will do the same for you guys as good as i can.. =)

I am current ly creating a scheduling system system for my school, as its name suggest it schedules subjects to certain time and certain rooms..

What i am now trying to do is when i input the ff into the combo box (not the real code but clear enough to see the scenario)

cboCourse = BS ECE


cboYear = V
cboSemester = 1st

following is an after_update event that create a table and will place the inputed values as name of the table then set the fields which im not going to include here because it isnt necessary..

i cannot set the newly created table as the RecordSource of a form..can you guys help me out?please leave a reply thank you..

[weekend00]

can't you just use:
Form.RecordSource=combobox1
to reset the record source?

Remember the new recordsource should has similar field names as the original source.
and don't forget put form.requery to refresh the form after changing recordsource.

[pbaldy]

You might want to review the chapter on normalization in your book. You probably should not be creating tables for the various combinations, if that's what you're doing.

[mann2x]

thx for the reply guys!i will try what you guys told me..and still i am open for new suggestions..