form based on three table query

[seeker]

I have a form which is based on following:

SELECT los_service.ID, tblMemberNameandAddress.LastName,
tblMemberNameandAddress.FirstName, los_service.member_number,
los_service.los_staff, los_service.los_service_date,
los_service.los_beg_time, los_service.nbr_of_minutes,
los_service.los_end_time, los_service.service, los_service.locnbr,
los_service.entered_in_MAF, los_service.entry_date, los_service.tcm_loc,
los_service_entry.los_service_id, los_service_entry.los_task_id,
los_service_entry.los_goal_id, los_service_entry.los_service_entry_date,
los_service_entry.los_service_entry_note, los_service_entry.FSA,
los_service_entry.GPR
FROM (los_service INNER JOIN los_service_entry ON los_service.ID =
los_service_entry.los_service_id) INNER JOIN tblMemberNameandAddress ON
los_service.member_number = tblMemberNameandAddress.MemberNumber
WHERE (((los_service.los_staff)=[Forms]![f_main]![cbo_entry_staff]) AND
((los_service.los_service_date)=[Forms]![f_main]![select_date]));

the textboxes that are enabled and not locked for the user to use will not
allow any data entry. How can I make it possible for the user without useing
dynaset (inconsistent updates) as a recordset type option. Thank you.

 

[orange]

It seems your form is based on a Select query which effectively is READ.
You also say the fields are not available for update. You could use snapshot
What is your concern with inconsistent updates?

 

[Klatuu]

You have created an uneditable recordset. I would recommend you design your
form so that it has two subforms. One for tblMemberNameandAddress and one
for los_service_entry