Identify each form

buzzbait9

Registered User.
Local time
Today, 17:43
Joined
May 19, 2015
Messages
18
I'm new to access so I think I'm just not adding 2 and 2 together. I need to make a form that bases itself on at table. The records are already available in that table and I have no problem chosing the ones I need when I need them.
When I choose a record, I need to add an issue date and have it list in a subform. Choose, Date, List. Next record, Choose, Date, List. etc. When the issues are complete, all of the issued records should be saved using a form ID (I tried autonumber) so I can query what was issued on each form instance. 1 ID to many Issued records. Can someone guide me to the right information? I feel like I've been reading a dictionary and still not finding the word I'm searching for.

Thanks
 
Thank you for the quick respose.
I have created the form it is working fine to enter info and to read info. I can search to locate each item etc.. I call it the Item information Form. Since it does what it needs to do, I think I'm stuck on using it inside an Issue form.
What I'm understanding , Progrqamming over 15 years ago(old school), is have a shell(Form) that is identified as Form ID. Then having a subform that allows me to view completed form with the many records I have available(Item information form). This, I guess, is so I can use the fully functional Item information form as it is intended without changing anything else, especially the form ID until I date and choose an item to issue.
Then once I date and choose what I want to issue, submit it to show on another subform in a list.

The end goal is to close and save the whole shell when I'm finished. The form ID will be 1 to many with the list of issued records and be able to be query'd as Form ID or Date of form etc.
The next time I open the shell to issue, it starts a new Form ID for the next batch.
I think I'm understanding what I need but not seeing how the gears fit.
The first step seems to be opening a Form with a Form ID that will stay the same until I Close and save. Inside this form have the fully functional Item Information form or the fields associated with it to find and list all the items I have without changing the Form ID. I must be missing the wizard step because I'm not getting that.
 

Users who are viewing this thread

Back
Top Bottom