Open Form to Specific Record not working for all records

I've created a customer db that lists customers (I.e. customerID, Cust Name) what I wan is once the user clicks the CustomerID for a specific record I want a separate details form to open and display the corresponding record.

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.

Sponsored Links:

Related Topics

MS Access go to specific record when open a form vba
I am working on a form that is bound to a table with user’s name. I need to be able to go to specific record base on a text box value which contain user login name, if there is no match then go to the new record for new entry. I want this to happen when the form open.

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.


Creating dynamic hyperlinks
I have a form that lists records in a table. I would like to have a hyperlink beside each record that will open the data entry form and navigate to that specific record. Right now, the use can only open the form for all records and has to use the record navigation buttons to find the desired record


How to open form on specific record?
I'm using the following code to open a form on a specific record. I have a form displaying records in a list which then allows users to click onto the record to open it up in a new form in a single view.

1) DoCmd.OpenForm "FRMBookingDetails", , "[BookingID] = " & Me.BookingID
2)
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.


Locate specific records in a database
As your database grows, locating specific records will involve more than a quick glance at a datasheet. In this article, learn five ways to locate specific records based on your needs.
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


FilterOn property...unable to add new record when opening form with the filter on??
I have a form with the record source set to a query with a couple thousand records. There are two places to open this form in my program. One from the switchboard and it displays all records in the query.

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
End Sub

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.


Open form to specific record based on combobox
Here is what I want to do.have a combobox that only displays records on a table where field = 0. got that.now I want to be able to click on record in combobox and have it open up the form to that 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


Filtering A Specific Record From A Form
I am trying to use a form that displays all 'outstanding' surveys and use a command button that opens another form diplaying thedetails of the 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.


Open Form to Specific Record
I have a db with two forms. When I leave Form A after working on a particular record and go to Form B, I would like to return to the record I was last working on when I exit B return to Form A. How would I accomplish that


Create a form that edits a specific record
I have a split database and I want to create a form on the front end that allows a user to go in and change a specific record. However, I have 200 records in the database, so a combobox is not realistic. Is there a way to find a specific record without a) scrolling through all of the records or b) using a combo box


Use Dialog Form to Define Recordsource and Go To Specific Record
I'm trying to build a form in Access 2003 which both defines the recordsource at the form's open event and lands on a specific record. I am able to do either one successfully, but not both. I use a dialog form to specify which set of records and which particular record I need. Then, the dialog form runs the following code:
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


Open a form to show the same record.
I need some help on creating a macro that will open a form a show a specific record automatically.

I have a form that shows some fields of a record, on double click I need to open another form that shows every filed of that specific record.

I need this to be as simple as possible.


click on datasheet to open a specific record in a form
I have two forms. One is a datasheet. One is a form with a default view of Single Form (which contains combo boxes).

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.


Opening form based on specific record only when combobox option is selected?
I have a database for tracking patients that could have many diagnoses, all of different types. I want the user to select a diagnosis from a combobox and then a form automatically opens where you can add details specific to that diagnosis. So for each separate diagnosis option, I need a different form to open.

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?


2003 When a form loads it doesn't "see" any records in the table that is the record source.
I have been working on an Access 2003 database that will be used to create and manage purchase requisitions. I had everything working justfine, but somehow things have gone off track.

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.


current record count and total record count on form
I currently have a form with a tab control on it, I have disabled the navigation bar on the bottom of the form to force compliance with specific controls and data flow on the form and tabs and didn't want the user to circumvent that security by using the navigation buttons of first record, previous record, next record, last record, or new record that come on the navigation baron forms unless disabled via the form properties.

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?


Open Specific Record
I have a form with a list of records displaying some basic information. I would like be able to double click on a record to open a second form displaying the records full information.


Possible to link a record in a report to that record within a specified form?
Have any of you ever linked a record in a report to a record within a form? In other words, if I would like to run a report that isolates a specific set of records, could I then make it possible to double click on the record within the report and open that record directly within the form that I want?


Creating a Switchboard button - search for record and open up specific form / report
I am in the process of creating a main switchboard for users to utilize when they open a database.

I already created a button, that allows them to use Form A to create a new record.

How can I create a button that allows them to search for a specific record (via either the Primary Key ID, Last Name, First Name, etc) and then it will open up the Form A for them to edit this record?

Also - how can I have them open up say a report that I create specific to that individual - the report will basically be a printer friendly version of the form - since it seems as though its hard to make a form printer friendly.


Open a form in another database to a specific record using VBA
I have two databases.
I would like to create a text box in the first database that users can type in the record Id of a record in the second database.

Then I would like the user to be able to double click that field which will launch the second database and open a form to that specific record id.


Open form to specific record
I'm working with Access 2010 and from a report, I want to use the On Click event with the "Title" control (on the report) to open my data entry form to the same record associated with the Title control.

I'm using a macro:

Form Name: Data Entry
View: Form
Filter Name: Blank (no entry)
Where Condition: [Position Number]=[Reports]![SRC Report (Bureau)]! [Position Number]
Date Mode: Edit
Window Mode: Dialog

This has worked and is working with a similar database, but when I click on the report control in this DB, the data entry form opens, but to the first record in the data set, not to the specific record where the [Position Number] fields match. Probably going to be one of those "duh" moments, but appreciate any help with this.