How do I set a link or macro up on one form to bring up another?

[Missionary2008]

Thanks for your help and advice in advance!

I have a datasheet form (List) that I'd like to be able to be able to click on the ID number and have it bring up another form (Details) for data entry.

I've tried setting up a macro and a hyperlink but what I end up with when I click on ID is the Details form with all the records in the DB. I just want it to bring up the one record to edit without the possibility of bringing up any other records for control purposes.

Can someone help walk me through this? Thanks.

[orangeCat]

@Missionary2008
I set up a small database - called ForBytes.mdb - that you can download at
http://www.4shared.com/dir/11648478/...0/sharing.html

It has a Table Product, and 2 forms - frmList and frmDetails.

Opening frmList will list all ProductCodes from table product.
If you click on a ProductCode on frmList, it will open frmDetails with a display of the field and values for that ProductCode,

Hope it helps, but I'm not sure exactly what you're trying to do.
The forms in the mdb do what you said, but I don't think that will get you very far.

[Missionary2008]

orangeCat,

Thanks for the response - that is exactly what I'm wanting my forms to do. Right now - when I click on the frmList it pulls up all the records from frmDetails. How do I get it to just rbing up the from for the one record I want to edit/look at?

Thanks in advance.

[orangeCat]

I'm not sure how, when clicking on a specific record in frmList, you're getting all records in frmDetails. That's not what's happening when I click on a record in frmList. In fact, the OpenForm command is specifcally restricting frmDetails to that record with the same productcode as the record you clicked on in frmLst.

Please explain.

[Missionary2008]

orangeCat,

It works on the db you created but no in mine.

I have a form entitle frmLists. when I open it - all the record are in datasheet view. I want to be able to click on the ID to bring up frmDetails just like it does in your db.

I've tried to use the embed a macro function bu (in the design view of the frmList) t when I do - it does open the frmDetails form - with all the records in my database and it always starts with the first record. I want it to open to frmDetails with only the record I click on in the frmList form.

How can I make the db open a different from when I click on the ID number in another form?

[orangeCat]

@Missionary2008
I'm not sure what your experience level is, but I sent the database so that you could see how clicking a record on one form would open a new form with details of the record you clicked on.

In frmList, there is a field "productcode". That field (control) has an private procedure related to the Onclick event.

Private Sub ProductCode_Click()
'
'When you click in the productCode field, this Sub
'will cause Form frmDetails to Open, and
'it will open displaying current entires for this Product code
'You can alter or enter new data in all fields except the product code field.
 
DoCmd.OpenForm "frmDetails", acNormal, , "Productcode = " & Forms!frmList.ProductCode
End Sub
 

This Sub does the following:

When you click on a record (the productcode in frmList), frmDetails is opened in Normal mode and the record it displays is the one that has its
ProductCode = to the Productcode you clicked on on form frmList.

To see this code, open frmList in design mode;
right click on the ProductCode field,
click Properties,
click Event,
Go to the OnClick event;
Click on the ellipses (.....) at the end of the line.

Good luck

[Missionary2008]

orangeCat

Thanks for your help - that last post helped out a lot. My experience is very limited as I'm still learning.

God bless.

[orangeCat]

@Missionary2008
Glad to help.
Here are some links to valuable Access Tips

1:http://www.fontstuff.com/siteindex.htm#access (tutorials an samples)
2: http://www.allenbrowne.com/casu-22.html (video and text)

[Missionary2008]

Great - Thanks! I appreciate the help.