Topics Search

Open Form to Specific Record not working for all records

Open Form to Specific Record not working for all records
Views: 8
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:

Similar posts...

 

How to open form on specific record?

How to open form on specific record? Icon
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.
 

MS Access go to specific record when open a form vba

MS Access go to specific record when open a form vba Icon
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.
 

FilterOn property...unable to add new record when opening form with the filter on??

FilterOn property...unable to add new record when opening form with the filter on?? Icon
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

Open form to specific record based on combobox Icon
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
 

Locate specific records in a database

Locate specific records in a database Icon
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
 

Filtering A Specific Record From A Form

Filtering A Specific Record From A Form Icon
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.
 

current record count and total record count on form

current record count and total record count on form Icon
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?
 

click on datasheet to open a specific record in a form

click on datasheet to open a specific record in a form Icon
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.
 

2003 When a form loads it doesn't "see" any records in the table that is the record source.

2003 When a form loads it doesn't "see" any records in the table that is the record source. Icon
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.
 

Opening form based on specific record only when combobox option is selected?

Opening form based on specific record only when combobox option is selected? Icon
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?