Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DoCmd.OpenForm Command
- Thread starter Mike555
- Start date
Trendsetter
Programmer
No Additions will only prevent the addition of new records.
If you want the user to see 1 record only then you need to specify that when you open the form:
DoCmd.OpenForm "frmViewClient",,,Where "ClientID=" & Me.ClientID
- frmViewClient would be changed to the name of the form you wish to open
- ClientID is the name of the field in the forms query that you wish the form to show
- Me.ClientID is the control at the location you are starting from that matched the record you wish to show
Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk
If you want the user to see 1 record only then you need to specify that when you open the form:
DoCmd.OpenForm "frmViewClient",,,Where "ClientID=" & Me.ClientID
- frmViewClient would be changed to the name of the form you wish to open
- ClientID is the name of the field in the forms query that you wish the form to show
- Me.ClientID is the control at the location you are starting from that matched the record you wish to show
Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk
- Status
Similar threads
- Locked
- Question