A query based on user input in form

[drhassan]

Ooh. Sorry for that. I uploaded by mistake the non-updated database.



Any way, there should be no null values in those four records because they are mandatory.

I have removed one combobox to follow the test and error concept.

I didn't change the RowSource of the Combo44 to test it as I'm really thinking to not use any comboboxes in my search form in case this problem is not going to be solved soon. However, let me try your suggestion and coming back to you.

Thank you for your patience with me and my problem(s).

[rpeare]

if your combo box is drawing from a table and you are using the PK as the bound column but you are looking up the text value of that in your query you'll have to do one of two things.

1. in your 'search' combo boxes eliminate the bound column and make the text value the bound column

EDIT: in other words your combo44 ROW SOURCE should be

SELECT [انواع الارساليات].الانواع FROM [انواع الارساليات];

OR

2. create a field on your form that is invisible, make the control source of that field

=combo44.column(1)

this is assuming that your bound column is 1 and it's the PK of the table with the values in it and the 2nd column actually contains the string you want to search for.

[rpeare]

one other option, sorry, is that because you're using the ID as the bound column in combo44 you'd have to search the ID field in your query, not the text value