form based on three table query

  • Thread starter Thread starter seeker
  • Start date Start date
S

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.
 
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?
 
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
 
Back
Top