Subforms And Combo Boxes

[Bob]

Hello, Access 2007.

I will try to explain my question as well as I know how, je je

I want to have a form that has a subform which is in data sheetveiw.

On the main form I would like to have 2 combo boxes on combo retrieves data
from a table called dates. the other combo box retrieves data from a table
called services. I would like to select a line from each combo box and when
I past data into the subform the line that is selected in each combobox be
put in it respective feild in the table for the subform..

I have tried this a number of way and am getting nowhere quickly.

Anohter small little question. When I am looking at my relationships the
simbles for 1 to many never appear in on line line, even though the
relationship is one to many.. Just an anoying little pet peave..

Thanks

Bob

 

[tkelley via AccessMonster.com]

Have you tried setting your default value of the two fields in question to
point to your combobox controls?

Forms!YourForm!ComboBox_1.value

?? Will that (or something similar) work?