Find Record action to display a record that is the current record on another for

Find Record action to display a record that is the current record on another for

Post by Tom K via » Wed, 02 Nov 2005 04:45:25

Can I use the Find Record action to display a record that is the current
record on another form. I tried to use the action Go To Control "AddressID"
then the action Find Record with "= Forms![frmNewAddress]![AddressID] " in
the find what box. The frmAddress is the current form and the form
frmNewAddress is also open.

This did not seem to work, and Im not sure why. Am I using the Find Record
action wrong?


Message posted via

1. Assign Child Records from Template Parent Record to Current Parent Record

2. Current Record Count, Previous Record #, Add New Record

I have a form with sub form for data entry. Linked together by master &
child primary key using combination of 2 fields for primary key. These
fields and values example are "CASE_YEAR" and value of 2004 and CASE_NUM and
value of 100, final key is 2004100. Field SEQ_NUM is added to secondary
table to differentiate between mutiple secondary records matching 1 primary
table record.

Primary table name is TST_FR_CASE_RECORDS
Secondary table name is TST_FR_CASE_OTHERS

Entry program works fine. But I have a problem sequencing numbers for these
tables when in UPDATE mode. User enters CASE number in form, table is
searched for match, when match found, is displayed in DATA ENTRY Mode = NO

I want the user to be able to scroll with scroll arrows in record navigation
bar to
previous and next records, but at the same time to have current record show
on sub form along with an unbound text box reflecting previous record
This unbound text field is called unbtxt_PREV_SEQ_NUM.

If user is on actual record Number 5 and previous record use was on was 4
then the
form would show current record SEQ_NUM of 5 for current record and 4 for

If user scrolls backwards, current record SEQNUM would be 4 and
unbtxt_PREV_SEQ_NUM would show 5. etc.

Also need to be able to add new records in update mode with ether an ADD NEW
RECORD COMMAND BUTTON or using >* arrow at navigation bar, and still be able
to keep SEQ_NUM current. When using DMAX on this function, I always get 21
in SEQ_NUM value instead of 6 if 6 would have been my next record.

I'm not VB code literate and would appreciate any information that could
resolve my deliema.

Robert Nusz @ DPS

3. Displaying record number against number of record displayed in a found set

4. How do you reference controls record by record on a form that displays many records?

5. Linking a PDF file of the current record to the current record

6. Using Find Record to display record from another form

7. Search and display record, and msgbox if record not found

8. Find button to locate record in form and display that record

9. find record in main form then find record in the subform

10. To find duplicate records in a query that is already finding duplicating records

11. I can't find records using the the find record command in a merged

12. Find records either side of the record found

13. Record Macro - Record custom user actions

14. Tab Cycle Current Record still goes to next record

15. "No Current Record" when adding new record