Beginner - Show multiple query in a form

[dommax]

Hello,

After looking up at several french forum, i did'nt found an answer to my problematic, so i come up to you.

I am a beginner in Access using .

I need to show 3 query on a form. I need to show this 3 query in 3 independent tables form. I would like that the users can't have an writing access on the "cells" into the table (Something like the table that Acess build for make a report). As you understood, this 3 table shall be only here for reading use.

I would like to add another features to my table. I'd like to have hypertext link on all the records of an access field (I don't know if my translation from french access vocabulary to english is great for the "field" word, i mean column by that...) which redirect the user to a form with all the information of the record selected.

Do you think that is feasible ? if yes, how would you do this ?

i attached a photo that describe what i want to do. I hope that will help you to understand my needs.



Thank you in advance.

[isladogs]

Suggest you use 3 subforms, each of which shows the results for one query.
Place the 3 subforms in your main form, one below the other

Hyperlink is the wrong word for your second question
You need to open your form filtered to the primary key field of the record selected
Do this either with code in the after update event of each control or use a button for that instead
If each item refers to the same record, only one button is needed

[dommax]

Thank you for your fast answering Ridders52 !

Ok i will try with 3 subforms. Do you know if it is possible to remove the buttons which are placed at the bottom of each form (the buttons that are used to switch to another record) ?

So, i use the "After Update" event and i use a macro to open one form that i have already build before and i filter it with the key selected into the table ? That seem great !

but, how can i know the primary key of the item selected ?

Thank you again..

[isladogs]

Thank you for your fast answering Ridders52 !

Ok i will try with 3 subforms. Do you know if it is possible to remove the buttons which are placed at the bottom of each form (the buttons that are used to switch to another record) ?

So, i use the "After Update" event and i use a macro to open one form that i have already build before and i filter it with the key selected into the table ? That seem great !
but, how can i know the primary key of the item selected ?

Thank you again..

Open the forms in design view (main & subforms), go to the Form Property sheet & set Record Selectors = No & Navigation Buttons = No
Suggest you use VBA event code to open the main form
I never use macros & suggest you don't as well. VBA is just as easy & much more powerful

Look at your table design for the primary key field
If it's a number field called ID and you have a textbox called txtID you could use code similar to this

DoCmd.OpenForm "MyFormName", , ,"ID = " & Me.txtID

For a text PK field, use text delimiters instead

DoCmd.OpenForm "MyFormName", , ,"ID = '" & Me.txtID & "'"

[dommax]

Ok so with this solution, i put a txtbox or a listbox and i use the value selected or typed in to open my form. In a first time i will do that.

is there a solution to do that in VBA ? : get the name of a specifc "cells" of a record when i click on a random cell of this record ? (In order to do the same thing that you mentionned above without txtbox)

I just was thinking about do this with a SQL query. something like "Select ID From mytable where [field_where_a_value_is_selected]='valueselected'". But that will not work because i can have some duplicate items in a field like "name"...

[isladogs]

Excel has cells. Access has records & fields

The reason I said to use the PK field is, by definition, that can't have duplicates.

You just need to have some means of referencing the PK field in your code.
It could be a hidden textbox so users aren't even aware of its existence

[dommax]

Sorry, i still have some difficulties to use the Access vocabulary.

This is what i've done. I created a form, and inserted inside a subform filled with one of my table. i added a Txtbox with the PK as source.

The only one remaining problem is that the txt box is linked to the main form and not to the subform. so when i select a record into the subform, the txtbox does not shows the record selected. but if i use the record selection button of the main form, it works.

Your advices are very useful.

[isladogs]

Go to Design view
Set the control source of your main form to the same table as your subform.
Then click on the edge of your subform so you are treating it as a control in your main form.
Go to the property sheet and link Parent and Child fields using your PK field

[ssanfu]

Can also use the double click event of controls in a record to open another form.....


And welcome to the forum......