i posted this twice already in the tables section but i guess that here is more appropriate for this kind of stuff
ok, thanks to all of you that helped me out until here, it wouldn't have been possible without you (could it?)
but iv'e now run into another problem: iv'e made some nice solution to my original problem (which i will post below): i changed to code accordingly and set the value of the text box to an integer, so there shouldn't be any data type mismatch so i don't get any errors and the combo list actually works half-way, the problem is that i'm prompted to enter a value into another window - why can't the combo box recognize the value that i typed in already?
here's the code:
Private Sub box1_AfterUpdate()
Dim ono As Integer
ono = box1
On Error Resume Next
co1.RowSource = "Select quotes.qID FROM quotes WHERE quotes.oID = ono ORDER BY quotes.qID;"
(ok, mind the on error resume next - it's not my original code, and i forgot to remove it)
how can i make a combo-box display ony values of a certain field that correspond only to that specific record:
for example, i have a table called "quotes" where the quotes are stored. there can be multiple quotes for the same order request - i.e. the "order" form (table) - they are linked together via the order number using a one-to-many relationship. the 'quotes' table is a subform on the 'order' form
but i wanted to add another field in the order form: i want a drop-down menu where the user can select which of the quotes was the final quote (that was actually ordered and processed). now i don't know how to do this: if i set the quotes table as the source then i will get the whole list of quoted from the whole database each time i open the menu, all i want to see is the few quotes that are related to that order no. (both the quotes and orders have seperate numbers: oID and qID)
here's the link to the whole thing
thanks for looking