Entry form with data linked to unupdatable recordset?

[kcn]

Hi,

I have two sets of data with a one to many relationship:

1. tblContact
2. tblHours

The files link using ContactID.

I’ve written a query- qryLimitHours – based on the “many” table that is not updatable.

I would like to create a form with a recordset from tblContact that is limited to the ContactIDs in qryLimitHours

The form should be continuous.

Any ideas?


Thanks,

Kerry

 

[PHV]

Join tblContact and tblHours on ContactID

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[kcn]

Hi,

Yes, it links via ContactID. And, actually, it limits the recordset! (I guess I was having problems earlier while playing around with the forms).

But what I need is to display the subform as a continuous form that doesn't require moving through the main form one record at a time.

thanks again!

 

[TheAceMan1]

How are ya kcn . . .

Have a look at faq702-5860

See Ya! . . . . . .