Manipulating data in a subform

[BrettM]

Hi guys,

I would like to be able to manipulate data in a subform based on info in two controls on the main form. The Main form is unlinked. The two controls allow the selection of names and dates.

The subform is based on controls referencing a table laid out as follows...

I would like the subform info to change based on the date chosen (referencing ActiveDate) and also based on the name chosen (referencing Name). So if Monica is chosen on the user control main form, only two lines are potentially available (2 & 4) and by putting "11/08/2008" in the date control on the main form, only line 4 is referenced. Change the date to "4/08/2008" and the reference is now line 2.

If the date referenced is not already in the table then a new record is created.

I am having difficulty getting my head around this. Any ideas would be greatly appreciated.

Regards Brett

 

[khawar]

Download the attached sample

 

[BrettM]

Perfect solution khawar. The query has now been "massaged" and fits my requirement exactly. Thanks for your help.

The scales have been weighted in your favour.

Brett

 

[dkinley]

I sent what little I had to you as a prime example of how to post.

-dK

 

[BrettM]

I sent what little I had to you as a prime example of how to post.

-dK

I have not had any previous replys from you. Do you have the right thread?

 

[dkinley]

No, no previous replies from me but was eavesdropping on thread is all. Saw the post, so tipped the scales to you.

-dK

 

[BrettM]

Thanks for the uplift. It is appreciated.

Regards Brett.