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.
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.
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.
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.
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
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
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.
I have placed my own command buttons on a specific tab in the form that I want the users to use to navigate through the records.
However, the problem with the above method is that I really would like the current record out of total records information label/box that comes standard on the navigation form!
Is there anyway that I can easily slap a label or textbox onto the specific tab in question that would display the current record count out of the total records in the database?
I want to have the user select (click) on a record in the
datasheet and have the second form open to that record. The datasheet form acts as an advanced search on two title fields.
I tried the open form macro but I don't know how to have to second form open to a specific record, I don't know how to set the "where condition" as some post suggested.
The database has a table called "ReqsTable" and a form called "ReqsForm". The record source for the form is the table. When a user opens the form, they can fill in the fields to create a new record,or they can use the standard navigation/arrow keys at the bottom of the form to move around and review or edit existing records. it is all pretty basic and has been working finefor several weeks.
But now when I open the ReqsForm it behaves as if ReqsTable has no records in it. It opens to a blank form and the text at the bottom of the window says I am on record 1 of 1. The navigation buttons are greyed out or non-functional.
There is no indication that any filter is applied and if I go back and open the table, all records are intact. If I enter new datainto the form and then close the form, that new data does appear as a new record at the end of the table, so the link between the form and the table is intact.
I know how to open a form to a specific record with the button wizard and I know how to write code that opens a specific form depending on which option is selected, but I don't know how to use them together.
then I don't need to use them together since I don't need to pull up a specific record, but I want the user to be able to double click any diagnosis that has already been entered, which will then pull up the corresponding form with that record so they can see the details of it.
So how can I put code in the double click event of the combobox that basically says if the option selected is this, then open this form, if the option selected is that, then open that form, etc. and ALSO open the form to the corresponding record?