How to save a record to a separate report in access

[megan1989]

I am a newbie with learning how to use the macros and VBA in access, so please bear with me. I am working with a database and I created a unbound form where I can type in whatever data I want. I know want to by use of a button be able to save that record to a corresponding report. I apologize and admit, I have no idea how to do this. Please help! Thanks

[June7]

If data is not saved into a table, there is no 'record'. Why are you using an unbound form?

You can either print the form, not always nice output, or textboxes on report can reference the textboxes of the form and then print the report.

[megan1989]

Okay, that does make sense. I am using the unbound form because originally I had created a form from a table but found I couldn't create any new records, which is why I created an unbound form. So what I need to do is to use the form with the records and find a way to add new records to that then I can update those records to a report, is that right? I am not sure how to do that, could you explain some of these to me. Thanks

[June7]

This is basic Access functionality. If you want to use form to add record then must move to new record row, unless the form has been configured not to allow new records.

[megan1989]

June, thank you for your advice. I think I've got a good idea on how to proceed. I was having a problem with the new record adding to the form because I was getting an error message "Record Not Updateable". From there I searched this on the web and was able to find why this was happening. Will have to change the structure of the database a little bit, but I think I will figure it out now. Thank you