whoknows361
Technical User
firstly, thanks all for your feedback thus far.. it has really helped.
table structure:
tbl_ReferralData
ReferralID (PK auto#)
Client Name
Client DOB
tbl_Assigned_Thx
ThxID(PK auto#)
ReferralID
Date TOC sent to billing
Date TOC rcvd from billing
Currently, I have frm_TOC_rcvd
i have a combobox (cmbo_ClientName) and a text field (DateRcvd) in this form. Also have a command button (btn_addDate)
the combo box lists ReferralID, Client Name, and Client DOB, which shows correctly (all from tbl_ReferralData)
I would like a user to click a client name, then enter a date in the DateRcvd text field.
When the user clicks on the command button I would like the Date entered to be added to the field "Date TOC rcvd from billing" in the tbl_assigned_thx. but it will require some filtering
I want the date that is entered in the form to be added to the "Date TOC rcvd from billing" field on the line of data which 1) matches the referral ID as chosen from the combobox and 2) wherein field "Date TOC sent to billing" has a date value in there & field "Date TOC rcvd from billing" has a value of "n/a"
only based on these 2 requirements will the date be entered into the correct field.
Can someone give me some insight onto how I might do this?
Appreciation as always
whoknows361
table structure:
tbl_ReferralData
ReferralID (PK auto#)
Client Name
Client DOB
tbl_Assigned_Thx
ThxID(PK auto#)
ReferralID
Date TOC sent to billing
Date TOC rcvd from billing
Currently, I have frm_TOC_rcvd
i have a combobox (cmbo_ClientName) and a text field (DateRcvd) in this form. Also have a command button (btn_addDate)
the combo box lists ReferralID, Client Name, and Client DOB, which shows correctly (all from tbl_ReferralData)
I would like a user to click a client name, then enter a date in the DateRcvd text field.
When the user clicks on the command button I would like the Date entered to be added to the field "Date TOC rcvd from billing" in the tbl_assigned_thx. but it will require some filtering
I want the date that is entered in the form to be added to the "Date TOC rcvd from billing" field on the line of data which 1) matches the referral ID as chosen from the combobox and 2) wherein field "Date TOC sent to billing" has a date value in there & field "Date TOC rcvd from billing" has a value of "n/a"
only based on these 2 requirements will the date be entered into the correct field.
Can someone give me some insight onto how I might do this?
Appreciation as always
whoknows361