If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Update Subform Query
Hi
I have a form called Adit. It contains general information (text boxes). The operator would add information and close the form. Say you add 3 lines. I have a form called Review. It contains general information and a [date closed] text box. An operator would open the Review form, view a subform which contained data (3 lines mentioned above) from the Audit Query. The audit query is based on a "null" closed date. So, I want to open the Review form, choose a line from the subform, say line 2, add a closed date (in the review form) and have the audit subform refresh to only show lines 1 and 3, again based on a null [closed date] value. Thank You |
#2
|
|||
|
|||
Update Subform Query
Humbled Learner -
If you do a Me.Requery in the subform's AfterUpdate event, it should remove the record with the closed date. -- Daryl S "Humbled Learner" wrote: Hi I have a form called Adit. It contains general information (text boxes). The operator would add information and close the form. Say you add 3 lines. I have a form called Review. It contains general information and a [date closed] text box. An operator would open the Review form, view a subform which contained data (3 lines mentioned above) from the Audit Query. The audit query is based on a "null" closed date. So, I want to open the Review form, choose a line from the subform, say line 2, add a closed date (in the review form) and have the audit subform refresh to only show lines 1 and 3, again based on a null [closed date] value. Thank You |
#3
|
|||
|
|||
Update Subform Query
You da Man! Thank You... one more small issue...
How will it know what line to add the date to? Should it be related to another field in the audit form? The auditor uses an identifer... like 123, 456 and 789 (for 3 line entries. When the reviewer types in 456 and the date, how will the query no to remove the 456 line and leave the 123 and 789 lines? Thank You "Daryl S" wrote: Humbled Learner - If you do a Me.Requery in the subform's AfterUpdate event, it should remove the record with the closed date. -- Daryl S "Humbled Learner" wrote: Hi I have a form called Adit. It contains general information (text boxes). The operator would add information and close the form. Say you add 3 lines. I have a form called Review. It contains general information and a [date closed] text box. An operator would open the Review form, view a subform which contained data (3 lines mentioned above) from the Audit Query. The audit query is based on a "null" closed date. So, I want to open the Review form, choose a line from the subform, say line 2, add a closed date (in the review form) and have the audit subform refresh to only show lines 1 and 3, again based on a null [closed date] value. Thank You |
#4
|
|||
|
|||
Update Subform Query
Humbled Learner -
I assume the user is typing the date on the record that needs to be updated. You said if three lines come up, the user would go to the line they want to update, and enter the close date there. If this is a normal subform with these fields bound to the database, then the record they put the close date on is the one that gets updated. -- Daryl S "Humbled Learner" wrote: You da Man! Thank You... one more small issue... How will it know what line to add the date to? Should it be related to another field in the audit form? The auditor uses an identifer... like 123, 456 and 789 (for 3 line entries. When the reviewer types in 456 and the date, how will the query no to remove the 456 line and leave the 123 and 789 lines? Thank You "Daryl S" wrote: Humbled Learner - If you do a Me.Requery in the subform's AfterUpdate event, it should remove the record with the closed date. -- Daryl S "Humbled Learner" wrote: Hi I have a form called Adit. It contains general information (text boxes). The operator would add information and close the form. Say you add 3 lines. I have a form called Review. It contains general information and a [date closed] text box. An operator would open the Review form, view a subform which contained data (3 lines mentioned above) from the Audit Query. The audit query is based on a "null" closed date. So, I want to open the Review form, choose a line from the subform, say line 2, add a closed date (in the review form) and have the audit subform refresh to only show lines 1 and 3, again based on a null [closed date] value. Thank You |
Thread Tools | |
Display Modes | |
|
|