Hi, so I have a MainForm and a Subform. The mainform has an autonumber assigned whenever you call it up, so that a new entry has an identifier. This is used for an RGA number (return goods). The mainform has some basic descriptors and then the Subform is used to enter the details; each item returned and its cause for return.
The subform is using a Select query to pull up a table and I can fill in a line, then another and this populates that tables rows with my data. What I am missing is how to get the autonumber (RGA#) from the mainform to be added to every line I fill on the subform. This will later call up all items related to an RGA everytime I view the mainform.
I have 1 form for entering a new RGA (mainform) and another form for edits to that RGA#. If I manually enter the RGA# then it works fine, but I cant get the form to enter the # for me. I copied a form that already did this entire process and I checked all the properties and cant find what I'm missing. I don't see any VB code performing this function on the other subform.
Any help would be appreciated, thanks!