Links within Microsoft Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is It Possible to have a link in a form in Access 2003 that goes from one
record to another record. If it is possible please tell me how, Thanks
 
Access doesn't use links, the way you might think of in a web page. You could
use a command button to navigate records. Create a new button. In it's
OnClick event, create a new macro. Use the Action GoToRecord. In the
properties, put:
Object Type: Form
Object Name: the name of your form
Record: Next

Save the macro. A click of the button will move to the next record. You
probably want another button/macro to move to the previous record.

Barry
 
I DO NOT know how to use Macros


Barry Gilbert said:
Access doesn't use links, the way you might think of in a web page. You could
use a command button to navigate records. Create a new button. In it's
OnClick event, create a new macro. Use the Action GoToRecord. In the
properties, put:
Object Type: Form
Object Name: the name of your form
Record: Next

Save the macro. A click of the button will move to the next record. You
probably want another button/macro to move to the previous record.

Barry
Click to expand...
 
Can You not READ.

I now how to do that? I asked is it possible to put a link on 1record in
1form TO another record in ANOTHER FORM.
 
Please don't be rude. I'm only trying to help. There was nothing in your
first posting that said anything about another form.

If you want help with something, please provide as explicit and complete a
question as possible.

Barry
 
Is It Possible to have a link in a form in Access 2003 that goes from one
record to another record. If it is possible please tell me how, Thanks
Click to expand...

Now that you cleared up that you want to launch another form, you make an
answer a bit easier.

However, I have not a clue what you mean by

"from one records to another record" ?

I mean, if you launch any form, it will launch to another record, usually
the first record of the table that the form is bound to.

So, what another record in this other form that you want to open to, what
record do you want to go to ?

Perhaps you question is:

How can a launch another form to open on the SAME record I am currently
editing?

You can use the following code to do this

me.Refresh
docmd.OpenForm "NameOfAnotherForm",,,"id = " & me!id

If the above is not want you are trying to do, then you will have to explain
what you mean by "another" record.
 
I apologise, I was slightly made because what google was looking for was
different from what i was wanting
 
I mean for example :

Record open ina form called "form 2" and then click on a link that will open
an associated link in say "form 5"
 
Eoin Neil said:
I mean for example :

Record open ina form called "form 2" and then click on a link that will
open
an associated link in say "form 5"
Click to expand...

You have still not explained what record you want this new form to open to?

Also, it is not clear at all what you mean by "associated link".

do you want form 5 to open to any old record?

Perhaps the first record in the forms bound table?
Perhaps the last record in the forms bound table?

Perhaps the SAME record that is currently being viewed in form 2?

Perhaps you want the form 5 to show all child records (those related) to the
current record in form 2?

You have to do a better job here. In your first post you even failed to
mention that you wanted to open another form!!!

We don't need a long question, but you certainly do have to clear up what
exactly you are trying to accomplish here.

To open, or launch another form, you can build the button with the wizard.
In design mode, simply drop a button onto your form 2 (when in design mode).
The wizard should start, and give you an option to build a button that
launches another form.

However, if you need that other form (form 5) in our discussion to open to a
particular record, then you have to provide more information as to what
record you want that form open to (or, if you don't care, then just use the
wizard as per above).
 
Back
Top