show all record in form

I have form "FrmLap" but that showing just only one record if I want to see all record what I should do?

I have main form "FrmMain" in that there is subform "SubLap" that is in datasheet view where I can see all record
and when user click in record selector on any record I can open just that specific record in "FrmLap" form but I want to see all record and when "FrmLap" open it should display that record.

suppose in my datasheet there 10 record if I click on record number 5 , I want that form should open with all 10 record but it should display record number 5 and if I click on next recordit should also show me record 6 like that.

Sponsored Links:

Related Topics

Close form and open the next record but have the same record show.
I have a form that is set In a split form that I use as a search form. It has the same fields that I have on my main form nthe problem that I am having is that once I select the record I find in the split form I want to be ale to close that form and to have the main form show that record.


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.


Form Refresh stopped working
In access 2003 I have a simple bound form with a few controls for name and address. The query in the recordset returns only one record so as to reduce network traffic.

I have a procedure that edits the query criteria so as to return just one record and then requeries the form to display the next record. Only problem is I cannot get form.requery to produce any effect.

If you run the query you see the new record while the form still shows the old one. Only when you re-open the form does the new records show. I've tried editing and saving the query manually to make sure that's OK but still no joy.

Is there any way to display the new record without re-opening the form? The query that is the record source of the form is:


Split Form Sync up
I am currently working with a split form in Access 2007. I don't know if it is possible, but when I go to update an existing record, The record on the bottom table area still has the old record values until I click on the record down there.

I know for new records it will show as soon as, changes are made in the upper form area. Is there a way to do this while updating a record


how to show new record page upon open split form
There may have a long listing of record and only some sort of record will be showing first page when split form is open, the page of record may not be at the new record, thus, I need to click the navigate record to "new", in order to insert new record.

So, I may want to set the split form to latest record page (do not in the midle of record) when open form.


How to show new record page upon open split form
There may have a long listing of record and only some sort of record will be showing first page when split form is open, the page of record may not be at the new record, thus, i need to click the navigate record to "new", in order to insert new record.

So, i may want to set the split form to latest record page (do not in the midle of record) when open form.


Form - New Record - Don't show existing
I'm developing a new database and have an opening form (A) with 2 options.
1) select an existing record number on Form (A) and open Form (B) only showing data belonging to that record. This l can achieve ok.

2) click a new record button on Form (A) and open Form (B) with a new record for editing but not showing any existing records and no way to go forward and backward in the record set.

I've tried changing the values in data entry but without success.


Message box if yes add a new record in the opening form
In the main form I have a button.On the click event the Msbox ask you if you want to add a new record or not in the opening form.
If yes I would like that the opening form was opening on a new record instead to show to me the last one. I tried with DoCmd.gotorecord,,acNew. but it doesn't work at (in fatc theopened form shows me the last record instead a new one)


Show all recordset in form/subform
I have a form that is set as single form and the subform is set to datasheet view. I want to show all records instead of just the last record that I created in the embedded Macro. No matter what I do I can't get all records to show. I like to have a new record on top with the rest of the records after.


Show all recordset in form/subform
I have a form that is set as single form and the subform is set to datasheet view. I want to show all records instead of just the last record that I created in the embedded Macro. No matter what I do I can't get all records to show. I like to have a new record on top with the rest of the records after.


Deleted then added record won't show in form
A record was deleted from an owner table which has a property table related to it. I couldn't add it back using the form, but could in the table. Nowmthe record exists with a different record number in the table than in the query & won't show at all in the form. Also, the property form will not I'm a rare user, but someone wants to pay me to fix this problem & I created it, trying to see what happens when a deletion is...


Record Numbers Displayed on Form
I am new to this site and rather new to Access as well. The users of my db have requested that the record numbers show on the form. I have found that it is possible on a report, but is there any way to show these numbers in the form view


Query criteria to show part of record
I have a search form with a txtbox where I type a LastName.
The query displays in a listbox all records with that LastName.
I then click on the record a open another form.
In this form I have a lot of data. One is the File Numer
Its format is 000A, 000b, 000c etc.

Each form shows only the file number of the record.
Is there a way I can add a textbox or listbox on the same form next to the File Number field, to show the last character (A, B, C) associated to that file number?

I know there is a Mid function but cannot make it work


Subform moving based on mainform
I have a mainform which shows a single record, I would like to have it also show the previous record.

The user is picking parts, the main area is to show them what to pick next and I want it to show what they just have picked.

I thought about having a subform which would contain the identical information from the main form but to always be a record behind? Perhaps this is the wrong way about going about it? I thought about when the user hits the "next part to pick" button it moves the main form on a record and then the subform shows MainFormRecord


opening a form with last one record.
I would like to ask about the opening a form through a command button where it can

- when form opend - showing last record.?

Normally opening it with

- Add mode - showing new record
- Normal mode - showing the 1st record.

please advise when open a form so must show up the last/latest one record


Moving to new record from a different form
I've got two forms. Form A which displays 'Customer purchases' and form B that allows the user to add customer details quickly (a sub form)

The issue I have is that I need requery form A upon closing from B to show the data added. This results in form A moving to record 1 rather than a new record that was previously selected.

Only thing I can think of is setting the onload of form A to:
DoCmd.GoToRecord , , acNewRec


How to sync records in datasheet form?
I have a single record form and a datasheet form. How is it possible to sync the record navigation of these forms? It would be nice if when a record is double clicked in the datasheet it causes the other form to show the same record.


ID Column of a Form
I have created a form and a report for my small and new database. I have added data to the form and all show up nicely in the report.

Problem is when one of my forms becomes outdated I delete it in order to keep my report up to date on the display monitor, then I get another order and I add a form so it shows up in the report and up to date on the display monitor.

After I delete and add a form, how can I get the ID column to reorder the records back in ascending order?

In other words, I have 6 records and I delete record number 3 and then add a new form. I still have 6 records and show 6 entry's on the report but the ID column now shows the last record as ID 7, and where record three was it now shows record 2 and the next one is record 4, it skips 3 because it was deleted and shows a 7 because it was added.

How can I get them to show ID's as 1 through 6 after deleting and adding forms automatically.


Parameter Search
I am creating a database but I wish to be able to click on a button a switchboard which will give me an option to Type in someones name, then it will find (if it exists) thier record and show me a FORM which contains thier record.

I am trying to do this by using a macro to place on the switchboard. how can I make this?

My idea is that first it opens the Form, ive got that far.
But now I dont know how to tell it to perform the good old `control+f` within the form to show a certain entry.

Dam my A-Level Coursework


Opening Record from a Listbox
I have created a form which allows for the user to search through records which are displayed in a listbox. My question is what do I need to do so that double clicking on a record in thelistbox opens up a different form with that record's details?

My listbox has no control source and is set to show 5 columns including the primary key. The form I want to open from this listbox has the same table listed as its record source. How do Igo about doing this?