PC Review

Thread Tools Rate Thread

linking form to record

Posts: n/a
      28th Apr 2005
I have 1 table: tbl_main
primary key is a field called JobNo

1 query: qry_main (this simply has all fields and just places the JobNo
field in ascending order).

I have 2 forms

I have created the main form where by the user simply presses a macro button
to open up the frm_bldInfo.
But when the frm_bldInfo opens, it does not open with the relevant
information for the record selected in the main form. The frm_bldInfo simply
shows the first record info in the database and not the relevant record
chosen initially in the main form.
Both the forms have their source as the qry_main.

Should I create a second table that has the bldinfo on its own then simply
create a query linking the two tables with the JobNo field ?
thanks for any help.

Reply With Quote
Joan Wild
Posts: n/a
      28th Apr 2005
John wrote:
> I have created the main form where by the user simply presses a macro
> button to open up the frm_bldInfo.

If you are using a macro, edit the macro Open Form action. In the lower
pane in the Where cell put

If you were using event procedure you would modify the code to include the
where clause

DoCmd.OpenForm "frm_bldInfo", , , [JobNo]=" & Me![JobNo]

Joan Wild
Microsoft Access MVP

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Linking a field in one form to open a record in another form Jeff Boyce Microsoft Access Forms 1 7th Apr 2009 07:03 PM
Linking a PDF file of the current record to the current record Angie Microsoft Access External Data 0 3rd Feb 2006 10:08 PM
Form code: how do I run code every time a record is "loaded" by going to next record, last record, etc. Dave R. Microsoft Access Macros 1 24th Jun 2005 07:37 PM
linking a specific record to a matching record in another form =?Utf-8?B?Q2Fyb2xN?= Microsoft Access Forms 2 6th May 2005 04:26 PM
I am trying to get a form to pick up the record data from a different record to this new record Thomas Simsion Microsoft Access Forms 4 10th Nov 2003 10:48 PM




All times are GMT +1. The time now is 06:45 AM.