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:
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)
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
So when the user clicks on a button in the Form B he is taken to the Form A. In case Form A has a record (CONTAINER) correspondent to key record in Form B, then the correct record is filtered based on the code:
However if there is no correspondent record in Form A there is a code on the Current state to create a new record showing the correspondent record name from Form B:
The first part where there are correspondent records works fine. The trouble starts when no correspondent record is found - Form A shows #Name? instead of a record name from Form B.
I have checked Control Source, Label names - everything is in order. Don't know where else to look.
When I save and close the 2nd form, the 1st form will not show the new record until I close and reopen it. Is there a way to update the 1st form after saving the new record in the 2nd form. See attached view of the two forms.
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?