Open Form to Specific Record not working for all records
DoCmd.OpenForm "CustomerExisting", acNormal, , "[CustomerID] =" & Me.CustomerID.Value, , acWindowNormal, Me.CustomerID.Value
But again it only works for some records not all,. Can't see any significant differences between records it will and wont open they all pretty much identical.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
The purpose of this is due to a multi-user environment application that I want the user to see his/her profile when open the form.
1) DoCmd.OpenForm "FRMBookingDetails", , "[BookingID] = " & Me.BookingID
The form opens only on the first record only and never the chosen record. Sometimes it opens the form on a new record.
I'm guessing this has something to do with filtering but not sure what I should be checking for.
Another from a form that filters to meet a specific Employee Number. When I open the form from the switchboard (all records) the last row is a blank record. When I open with the filter on, the blank record does not exist. I have "Allow Additions" set to true, so what is causing this behavior?
Private Sub btnAddNewRecord_Click()
DoCmd.GoToRecord , , acNewRec 'goes to open record
Me.cboDriverNumber.SetFocus 'sets focus to combo box
It works fine when I open from the switchboard (with all records displayed from the query). It does not work and there is no blank record when I open it from the form with the filter applied.
What do you want to do?
* Browse through all records
* Go to a specific record
* Search for a specific record
* Filter to see a limited number of records
* Create a query to find a specific record
So far I have combobox with.
SELECT tblLoad.LoadID, tblLoad.LoadDate, tblLoad.AutoclaveID, tblLoad.LoadNumber, tblLoad.[Cycle Complete] FROM tblLoad WHERE (((tblLoad.[Cycle Complete])=0));
Bound Column is 1
This works to limit records shown in combbox.yea!
Now I can't figure out how to open form to that particular record.have tried several things in afterupdate of combobox.but no luck
I have a feeling that this isn't working due to the subform's on the 'Survey' form that open's displaying the specific record. The database table's will need to be re-linked to CSS_BE.mdb before opening.
DoCmd.OpenForm frmSomeForm, , , "[somefield] = " & Me.somefieldvalue, , , Me.OpenArgs The somefieldvalue is the record I want to land on. The Me.OpenArgs value is passed to frmSomeForm and processed on that form's open event to determine the recordsource. What happens is that I get the correct recordsource, but am landing on the first record, not the one I want. I have also tried passing both values as a compound OpenArg, but this yields the same result when I open the new form. I have wasted an unbelievable amount of time playing with this and cannot get both things to happen - it's either one or the other