Combo boxes dont work - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Combo boxes dont work

Masih Ostad Novin

2 years ago

Hi.
I have this situation. I choose an antibody pair. 2 comboboxes: Lot1 and Lot2 have to display lots for first antibody (Lot1) and second antibody (Lot2).
If I omit where conditions from the boxes then they display correctly (pic 6). With where condition they don't display nothing. To be clear, ID 16 is lot 1 (antibody 1) and ID 64 is Lot 2 (antibody 2). What is wrong with my where conditions?
Thanks
Masih

	Masih Ostad Novin OP @Reply 2 years ago

	Masih Ostad Novin OP @Reply 2 years ago

	Masih Ostad Novin OP @Reply 2 years ago

	Masih Ostad Novin OP @Reply 2 years ago

	Masih Ostad Novin OP @Reply 2 years ago

	Masih Ostad Novin OP @Reply 2 years ago

	Kevin Robertson @Reply 2 years ago
The only thing I notice is you have aliased one of your fields with 'Count'. This is a Reserved Word (A function). Consider changing it then get back to us.

	Masih Ostad Novin OP @Reply 2 years ago
OK. I changed count but still doesn't work.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View