Open Form to Particular Record

  • Thread starter Thread starter RC-
  • Start date Start date
R

RC-

I have a form that is reading data from "Table1". If a user selects a record
and then clicks "Modify", how can I open another form in Continuous Forms
view based on the same table "Table1" and have the same record selected from
the previous form?

The reason I am doing this is I don't want the end user to be able to make
changes in the "Default" form but rather in the Add/Delete form.

Thanks in advance,
RC-
 
Use the WhereCondition of the OpenForm method to filter the popped up form:

DoCmd.OpenForm FormName:="frmMyEditForm", WhereCondition:="[MyKeyField] = "
& Me.MyKeyField

Look in Access help for more info on this command.

Barry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to limit insertion of records 3
Display a record in a form 1
Form Problems 1
Compare 2 tables and delete from one of them 2
Problem deleting records 1
Skip Records in a Form 2
Access Automatically Send a notification email once a record is added 0
Tables 3

Back
Top