show all record in form

Views: 33

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.

Similar posts...

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.

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:

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

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.

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.

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)

Have a db with 10 forms. Regardless of which form is opened.a user will search for a record to modify. If they move to another form I need to keep that record id alive so the next form is automatically on that record. Thoughts?
I was going to do a little macro that would fire on each form open and check a VBA snippet for a record id. If not null, load said record, else load first record