Open button for single record

[tania20]

Hi, I have a form which shows all the records for a table.I want some way to have a button next to the fields for one record that will open another form based on one field of the selected record. I know how to achieve through using a yes/no control and applying a search criteria based on this....but to me this involves two actions as opposed to one which is not very efficient.Does anyone have any ideas to point me in the right direction?

Cheers

Tania

 

[boblarson]

You can open a form, or report, to a single record by using:
for form:
DoCmd.OpenForm "YourFormNameHere", acViewNormal,,"[YourIDFieldOnFormYouAreOpening]=" & Me!YourKeyFieldThatMatchesUpWithTheOther

If matching text then you need to add single quotes:
DoCmd.OpenForm "YourFormNameHere", acViewNormal,,"[YourIDFieldOnFormYouAreOpening]='" & Me!YourKeyFieldThatMatchesUpWithTheOther & "'"

for a report:
DoCmd.OpenReport "YourReportNameHere", acViewPreview,,"[YourIDFieldOnFormYouAreOpening]=" & Me!YourKeyFieldThatMatchesUpWithTheOther

and the same as above using single quotes if matching text. If matching dates, use # marks instead of single quotes.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com