Phil,
Thank you and I used your suggestions.
The reason for the other Inspector table (tbl_inspectors _1) this was created by my sup to use as a lookup. Users will be able to select Inspectors via a combo box in the subform.
Yes, there can be many inspectors for a single Report.
I changed the name to Issue (was trying to remember if you had put Issue or Incident oops).
Thus far I left the subforms as datasheets...
devlearner
Last Activity: Dec 12 '18, 12:18 PM
Joined: Aug 1 '18
Location: Trinidad
-
My apologies for the confusion.
The Report which is the main form has a PK - ReportID which is a part of the other tables as an FK.
Compliant and Report has a one-to-many relationship (ReportID).
I was asked to create the dialog-form within the Compliant and NonCompliant subforms to allow users to create many Compliant/NonCompliant and have it populate in the subforms datasheet view.
My issue is how do I get the dialog...Leave a comment:
-
Noted.
Honestly, this wasn't my idea to even do a dialog form. I keep having to add stuff along the way because my sup says so. Yes, I am the one developing it but it seems that what you learn in university isn't always applied in the real world.
It's so confusing for me too, to even grasp the logic of why a dialog form that is connected to the same record source.
I gather that the purpose of the dialog form is to prevent...Leave a comment:
-
Hi zmbd
I do not have any VBA code for the forms.
For the subform inside the main form, there exists a tab control and this subform resides on one of the pages.
This subform is datasheet view and suppose to reflect data entered on the dialog form. The dialog form is opened using a button with macro control. This was easy for me because I honestly don't know VBA code. My sup told me its a simple line of code but what exactly...Leave a comment:
-
How to get the subform to refresh after entering data on a dialog form
Working with Access 2013
I have a subform that is part of the main report form. I want users to see entries which they would enter using the dialog form (that should be connected with this subform). The subform is in Datasheet view since there are many 'Compliance' associated with the report.
I tried using a DoCmd.Requery in the AfterUpdate and also the form load.
Don't know much of VBA code but someone told me it's one line,...Last edited by devlearner; Aug 1 '18, 11:51 PM. Reason: trying to be as straightforward with the question. thank you
No activity results to display
Leave a comment: