show all record in form
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.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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 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
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.
So, i may want to set the split form to latest record page (do not in the midle of record) when open form.
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.
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)
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
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
- 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