missing operator

[swmorin]

currentdb.OpenRecordset("select * from tbl_list_281_types where tbl_list_281_types.281ID = [Forms]![frm_create_instructor]![Combo1]")

It says its missing an operator in the where statement

 

[vbaInet]

swmorin,

A table name like 281_types does sounds suspiciously un-normalized.

Regarding your problem, I believe Combo1 doesn't contain anything.

 

[boblarson]

Also, you might try concatenating the form reference in so that the explicit value is being passed instead of requiring it to evaluate the form reference itself.

currentdb.OpenRecordset("select * from tbl_list_281_types where [281ID] = " & [Forms]![frm_create_instructor]![Combo1])

 

[swmorin]

Bob thanks that worked,

VbaInet, I think I have normalized my db.

I am attaching a copy tell me what I have messed up.

 

[vbaInet]

I can't be of much help here without understanding your business logic, but besides that this isn't the right section for this question. I've a quick look and I can see that you have no relationships setup.

If you require advice regarding your tables and their relationships you can post a thread in the Tables section of the forum and explain what each table is for + your business logic.

 

[boblarson]

If you require advice regarding your tables and their relationships you can post a thread in the Tables section of the forum

The better spot for that is the Theory and Practice of Database Design section.

 

[vbaInet]

The better spot for that is the Theory and Practice of Database Design section.

Sometimes I ask posters to post there but there doesn't seem to be much activity there. Perhaps if we start telling them to go there there will more activity.