Hi, I am a new base user. I have created a table called veg. I have created a query to display entries in this table corresponding to specific “year” values. I then created a form to display the query results. Is it possible to display the query results as a datasheet and then “click” on a row of my choice of this datasheet to display the corresponding entry on a form. Ideally I would then be able to navigate (through buttons I would have added to the form) to other entries as needed.
Any help with this would be much appreciated. I am 70 years old and new to this and am keen to learn.
The query is data source of the mainform of the database form document. So you could create a subform, which will show only the content from the “row of your choice”.
A subform could be created through Form → Form Navigator → Right Mouseclick on MainForm.
You will need to connect this subform with the mainform by some fields of your query, which is datasource in the main form.
Thank you for replying Robert.
Forgive me for not quite understanding, your reply:
When i run the query i get a datasheet view with rows showing me the results.
What i am hoping to do is to be able to “mouse click” on any of the rows displayed (row of my choice) and this will then bring up this row on a seperate form.
This form would have “buttons” on it that i could use to then navigate through the other records displayed by the query as i wish , displaying them individually as i go.
Hope this makes sense.
The database i have made has over 30 yrs worth of vegetable growing and showing records in it and i would like to be able to interrogate it as i have tried to explain.
If it helps i could send it to you so you can visualise what i mean.
If you are unable to help further, please accept my thanks for your help to date.
Regards
George Williams.
This would be the “Main Form” Base’s standard way to do things.
When you OPEN THE FORM you get a “grid” view whose data source is the query.
This “grid” is a TableControl you place in the (Main) Form.
In the “standard” way you should have a “Sub Form” linked to the Main. So as you navigate the Main’s records, details of the selected one will display in this Sub Form (not in a “grid” view).
But of course you can choose to open up another Form, instead of having the “standard way” so to speak Sub Form in the same window.
Yes, to try helping in a specific way, you should upload a perhaps dummy stripped-down version of you DB. With your veg. Table and the Form you created. No need of real data of course, it is the design that matters.
Roger, how do i send you this please?