Search results

I did it! I love you!

I’ve got the text box setup to display the auto number field which for me is ‘ID’. Now I just need to get that ID value into the ‘Criteria’ box on the query right?

Aha! That makes sense... So I need to find a way for the form to ‘know’ which ID it is in the table, filter a query by that ID and then generate a report of that query. I’m not all of the way there yet but that has helped a lot, thanks :)

No, just the data that they have entered in that single form’s ‘session’. When they press submit at the end it will add the information into a table and I would like a report of just that single records unfiltered data. Currently it adds that data to the table but I have one report that shows...

I want all of the information that is entered on the form to be displayed on the report so I don’t think I need a query to filter things out (?) The report currently grabs info from a table and displays a report for each record in the table but in one long report/document. I just want to...

I’ve created a query and can see the criteria box. Should I be creating a criteria that handles the whole behaviour that I want or just displaying a single report at once? I’ve never used criteria/queries so this is quite confusing for me. Sorry :/

Then I must be way out of my depths here because I don’t understand. This is so frustrating :( I don’t have a query at the moment, I just have a table that gets populated once the form has been completed.

I appreciate the reply but I think I need something a bit more dynamic. Access needs to know that at the end of the form when a ‘submit’ button is pressed it should display the information that has just been entered in a report and then export it as a PDF.

I am pretty new to Microsoft Access so go easy on me. I am attempting to create a system where a user completes a form, generates a report and uploads it to a LAN. Currently I have the form working fine and a formatted report with all of the tables records displayed over several pages. I would...