opening a certain report based on a field in a form

[halo123456789]

I'm new to access and I am making a simple database for the record I have for my students.



I want to open a specific report based on the registration number [which is the autonumber] given on their form so that I can print it. I made another form for this so I can filter it. The new form is the one below.



I do not know what code to write so I can open the report based on the unique registration number/surname. I stopped at DoCmd.OpenReport "Form Print", acViewPreview.

Thank you in advance.

[June7]

Use the WHERE CONDITION argument. Assuming registration number is a text field, something like:

DoCmd.OpenReport "Form Print", acViewPreview, , "RegistrationNumber='" & Me.tbxRegistration & "'"

Review http://allenbrowne.com/ser-62.html

Suggest you use comboboxes instead of textboxes.

[halo123456789]

I tried but it is still not working. Whenever I enter the registration number and clicked open, It still shows the first report, not the one with the same registration number or surname.

I already made this work before but the code was tampered and I cannot remember it anymore.

[June7]

If you want to provide db for analysis, follow instructions at bottom of my post.

[halo123456789]

cant seem to attach the files even after following the instructions. always failed. the zip file is still too big.

[June7]

Up to 2mb zip allowed. More than one file is allowed.

Maybe can figure out what is wrong if you just post the code.

[halo123456789]

It is something like this

Private Sub open_Click()
DoCmd.OpenReport "Form Print", acViewPreview, , "RegistrationNumber=" & Me.txbRegitrationNumber & ""
End

it opens the report, but now the print view and not the one with the same registration number.
and the print command button doesnt do anything either.

[halo123456789]

http://www.mediafire.com/file/hjsn4w...opy.accdb/file

idk if this works but i uploaded the db in mediafire

[June7]

I tried that link and my computer freezes on that page. Had to reboot computer. I'm never going to that site again. I use Box.com, never had an issue with it. Many won't download files from other sites. Really need to zip and attach to forum post.

[halo123456789]

new.zip new.zip i am so sorry about that. i didnt know that would happen.

i tried to export some data into this new db.

[orange]

Just took a quick look at your database and would offer the points for consideration.

-Every table in a relational database should have a Primary Key.
-In Access all field and object names should NOT contain embedded spaces nor special characters
-A brief description of the purpose of your proposed database in simple, plain English helps the reader understand your requirement

There are several articles on Database Planning and Design at the link in my signature.

Good luck with your project.

[mike60smart]

Hi
As orange has mentioned there are points you need to address with this database.

Main one being Autonumber - Primary Keys
You have Lookup fields at table level which are NOT recommended.

If you look at the revised database I have modified the Print / Open Command button's VB so that it now only opens the Student you have specified.

I would recommend that you change these Unbound Textbox's to Combobox's which would allow you to search for the specific Registration Number and Student Name

[halo123456789]

omg. thank you so much. i'll take these into consideration.