Any suggestions

[D R Tester]

I have set up a database in access that is used to store different subsets
of data about an entity. The database stoes details about specific companies
and is normalised - I have 4 tables holding data regarding community
involvement, contact details, activity. There are quite a few fields in each
table. I want to be able to view each company record at a time. But want to
use buttons down the side to access the fields held in specific tables. I.e.
when button is clicked on - it pulls a form that displays that specific
record's detail on community involvement for example.

Whats the best way of achieiving this?

Regards,

D R Tester

[Reggie]

DR, Lookup the OpenArgs under the help menu and see if this will do. If not
post back.

--
Reggie

----------
"D R Tester" <dr.tester[nospam]@ntlworldnospam.com> wrote in message
news:ze***************@newsfe1-gui.ntli.net...

I have set up a database in access that is used to store different subsets
of data about an entity. The database stoes details about specific companies and is normalised - I have 4 tables holding data regarding community
involvement, contact details, activity. There are quite a few fields in each table. I want to be able to view each company record at a time. But want to use buttons down the side to access the fields held in specific tables. I.e. when button is clicked on - it pulls a form that displays that specific
record's detail on community involvement for example.

Whats the best way of achieiving this?

Regards,

D R Tester

[D R Tester]

Hmm,
Still not having any luck. Had a look at openargs - still none the wiser to
solve this problem. I have reviewed my intial post - perhaps it would be
simpler to state that I would like to have a button on a form that opens up
a different form and displays the data from a different table that relates
to the current record.

Dom
"Reggie" <No**********@NoSpamsmittysinet.com> wrote in message
news:79********************@comcast.com...

DR, Lookup the OpenArgs under the help menu and see if this will do. If not post back.

--
Reggie

----------
"D R Tester" <dr.tester[nospam]@ntlworldnospam.com> wrote in message
news:ze***************@newsfe1-gui.ntli.net...

I have set up a database in access that is used to store different subsets of data about an entity. The database stoes details about specific

companies

and is normalised - I have 4 tables holding data regarding community
involvement, contact details, activity. There are quite a few fields in

each

table. I want to be able to view each company record at a time. But want

to

use buttons down the side to access the fields held in specific tables.

I.e.

when button is clicked on - it pulls a form that displays that specific
record's detail on community involvement for example.

Whats the best way of achieiving this?

Regards,

D R Tester

[Jim Allensworth]

On Sat, 17 Jul 2004 15:57:11 GMT, "D R Tester"
<dr.tester[nospam]@ntlworldnospam.com> wrote:

Hmm,
Still not having any luck. Had a look at openargs - still none the wiser to
solve this problem. I have reviewed my intial post - perhaps it would be
simpler to state that I would like to have a button on a form that opens up
a different form and displays the data from a different table that relates
to the current record.

DoCmd.OpenForm "frmMyForm",,,"RelatedField=" & Me.RelatedField

If the related field is text the surround the value in single
quotes...

DoCmd.OpenForm "frmMyForm",,,"RelatedField='" & Me.RelatedField & "'"

- Jim

[Reggie]

Dr, One other thing you could do is design a query using the table(s) you
want to use for the record source of the form to be opened. In the criteria
row under the field you are trying to filter type in something like this
replacing the names here with the name of the control on your form.
=Forms!frmYourForm!ControlName

So for instance if your initial form was called frmContacts and you had a
control on the form named ContactID you would enter
=Forms!frmContacts!ContactID in the criteria row under the ContactID field
in the query. Use this query as the recordsource for your frmContactDetails
form for example. Now when you open the frmContactDetails it will open to
whatever record(s) that match the ContactID control on your frmContacts
form. Hope this helps.
--
Reggie

----------
"Jim Allensworth" <Ji****@datacentricsolutions.com> wrote in message
news:40**************@netnews.comcast.net...

On Sat, 17 Jul 2004 15:57:11 GMT, "D R Tester"
<dr.tester[nospam]@ntlworldnospam.com> wrote:

Hmm,
Still not having any luck. Had a look at openargs - still none the wiser tosolve this problem. I have reviewed my intial post - perhaps it would be
simpler to state that I would like to have a button on a form that opens upa different form and displays the data from a different table that relatesto the current record.

DoCmd.OpenForm "frmMyForm",,,"RelatedField=" & Me.RelatedField

If the related field is text the surround the value in single
quotes...

DoCmd.OpenForm "frmMyForm",,,"RelatedField='" & Me.RelatedField & "'"

- Jim