Forms :: Subform Record Selector Moving?

Aug 21, 2014

When moving from a subform back to the mainform and requerying one of the mainform controls, the record selector of the subform moves back to its first record. ...

GoToRecord (,,Next) '(in the subform-this is correct)
SelectObject
Object Type Form
Object Name pv '(go back to the main form)
In Database Window No
GoToControl (SubTot)

Requery (SubTot)If I remove the Requery, the record selector remains where it is supposed to be. The SubTot data source does include the aggregate dsum value of the subform's underlying table. What is strange is that this has been running properly for many years until it was upgraded from .mdb to .accdb format. Is there an easy way to make the record selector stay put?

View Replies


ADVERTISEMENT

Forms :: Main Form Jumps Back To 1st Record When Moving To Next Record In Subform?

Mar 24, 2015

When I add a record in the subform and then move to the next record whilst still in the subform, the main form jumps back to its first record? I then have to move back to the right record in the main form to update the next record in the subform.

I want to move to the next record in the subform without affecting the main form.

View 1 Replies View Related

Forms :: Saving New Record When Moving To Another Record In Same Subform

Jan 17, 2014

I have a subform with records of call details (date, time, subject) - the date and time are autogenerated and subject is a text field. After entering text in the subject field and then clicking on the close button in the main form, or clicking anywhere else in the main form, the record is saved to the table. However, if I enter text in the subject field and then move up to view previous records (within the subform) and then click the close button in the main form the record is not saved in the table. How can I either save the record before allowing the user to move to another record within the subform or before exiting the subform set the focus to the new record so that it will be saved on exit?

View 4 Replies View Related

Problem With SubForm - Record Selector Always Jumps To First Record

May 29, 2006

In the zip-file attached below is my "problem" database. (to see the problem open frmLedenArtikels)
On top of the form just select a name from the combo box, the subform then lists the items that person has bought on a certain date. So very easy form.

The problem is the following. When I try to add items to the subform, the record selector in the subform always automatically jumps back to the first record in the subform. this is very annoying and I have totally no clue why this is happening.

View 2 Replies View Related

Forms :: Combo Record Selector Using Either ID Or Username

Jul 19, 2013

My problem is related to an Access database, where an auto complete Combo box is used to select a client record by entering the ID number or the clients name. EG: 14034 or Bloggs,Fred. This problem has me puzzled (not difficult to do).I have seen this in a functioning DB. I can see that maybe the ID (a long integer) would have to be stored or converted to a string on the fly.

I am currently using Access 2007 but 2010 and 2013 are available (prefer 2007 as MS keep moving things around ).I am currently selecting a client record using either an ID select Combo or a ClientName Combo and works very well. But, after seeing it done in one Combo box, it just seems so elegant.

View 1 Replies View Related

Forms :: Stop Record Selector On Form?

Nov 15, 2013

I am using Access 2013. I have a form with 2 subforms, each time the form is opened, the first record on both subforms are selected. Is there a way to turn off the record selector so no records are selected when the form opens?

View 3 Replies View Related

Forms :: Combo Box Record Selector AfterUpdate Macro

Jun 18, 2015

I have a form that has a Combo box record selector which works fine. I need to add more to the Where condition of this macro.

Combo1 - Options 1-Facility, 2-Physician (referral_type)

Combo2 - Record selector that works, either shows a list of facilities or list of physicians.
Macro SearchForRecord - Where Condition ="[fac_id] = " & Str(Nz([Screen].[ActiveControl].[Column](0),0))

Would like it to be

="[fac_id] = " & Str(Nz([Screen].[ActiveControl].[Column](0),0)) AND [referral_type] = Me!Combo2

Have tried a few different things with no luck.

View 5 Replies View Related

Moving From A Subform Within Multi-Page Tab To Selected Record And Tab?

Mar 30, 2015

I have a Form named Clients with a multi-page tab named TabCtl0.

The record source tables - primary key is [ID] , TabCtl0 has 7 tabs, the 1st named General.

The 1st 6 tabs show information from the same record.

The 7th tab contains a subform named Focus displaying continuous forms with 3 fields in each record including [ID].

What I am trying (for hours and hours without success) to do is to create a Macro that fires when I double click on a control within subform Focus that takes me to the page named General and selects the record where ID = the ID within the selected record of subform focus.

View 1 Replies View Related

Forms :: Moving A Subform Within A Subform Of A Form?

Aug 19, 2015

I often move sub forms up and down within a form using something like.

Code:

forms!MyMainForm!MySubform.form.top = 500

However, I am having trouble moving a subform within a subform of a form.

Code:

Forms!MyMainForm!!MySubform!MySubformSubForm.form.top = 500

View 1 Replies View Related

Forms :: Moving From One Subform To Another

Aug 28, 2013

I have two subforms on a main form. When I move out of the last control of the first subform, I use the following code to move to the first control of the second subform:

Forms!frmFMVisit!frmSubFamilyEthnicDetails.SetFocu s

This is giving me problems in that it appears that moving out of the control in this way seems to be creating a record in the table on which the first subform is based.I get the following message: 'Cannot the value 'NULL' into column 'DoB'; column does not allow nulls. INSERT fails.'Is there a way to navigate between subforms without this happening?

View 5 Replies View Related

Forms :: Data Moving Around On Subform

May 8, 2015

I have a form on my database called frmFloorRun in which a user inputs a line number on the main form, and then in the subform they enter what will be running on that line for that given day.

Everything seems to work beautifully except that when a user clicks on a line other than line 1 and clicks the refresh button, the first item scheduled to run on line 1 will move to whatever line the user is currently on.

To replicate this issue: simply open the database (i have slimmed it down so that only the floor run portion is included).

Open the form [frmFloorRun] observe the first line item on line 1 (that should be what the form opens to by default).

Now click on any other line by selecting it from the dropdown (yes I realize it is a combo box, but even when I remove that combo box and enter a line number manually, the issue persists).

After selecting another line, click refresh and that first line item from line 1 will move to whatever line you have selected. This is a huge issue for our company.

Also, I have included the report that is based on this form. It simply proves that the line item does not just move on the form - it moves in the report too.

View 2 Replies View Related

Modules & VBA :: Highlight Record On Click Record Selector In Continuous Form

Oct 23, 2014

I would like to highlight record when user will click Record Selector in the continuous form. How to do it?

View 1 Replies View Related

Record Selector

May 9, 2006

Hi

Does anyone know how to remove the "Record ID" from the record selector? I want to be able to traverse from one record to the next, however I do not want the field representing what record it is on showing up ( if that makes any sense).

Thanks

View 3 Replies View Related

Preventing Record Selector, Creating New Record

May 18, 2005

Hi All,
I have a form that when loads, runs some VBA on the "On Current" event.
Some of that code, fills in text boxes, with concatenated (?) strings.
So every time I use the record selector and get to the end of all the records, the "On Current" fires adds the concatenated string (even if it's empty), and that then becomes a new record! Is there some way i can prevent this, but still keep the "On Current" event, some type of logic I could run before the concatenations etc.

Any Help would be appreciated.

Cheers

BAzZ

View 2 Replies View Related

Remove Record Selector

Mar 22, 2006

How do I remove a record selector from a subform? I went to the actual form for the subform and went into design view. I changed the record selector to NO and it is still there.

View 2 Replies View Related

Record Selector Sync

Aug 27, 2006

I have a table with fields ID, NAME, ITEM, QUANTITY and DATE_IN. I have a query "qry_Logged_In" based on the table. I then have a form based on the query.

I created a combo box as a "go to record" selector and used the following Row Source:

SELECT DISTINCTROW qry_Logged_In.ID, qry_Logged_In.NAME, qry_Logged_In.ITEM, qry_Logged_In.QUANTITY, qry_Logged_In.DATE_IN FROM qry_Logged_In ORDER BY [ID];

On the After Update proceudre I have the following code:

Sub Combo135_AfterUpdate()
' Find the record that matches the control.
Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo135]
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub

It works fine, but one thing I would like is that as I toggle through records using the record selector (forward/backward) buttons, I would like for the record number in my combo box to also change keeping in sync with the record number. Unfortunately, it currently stays to the number I last selected in the combo box.

Any suggestions on how to make the record number showing in my combo box to change with the record number?

Thanks,
Jim

View 7 Replies View Related

Forms :: Combo Box Not Updating Upon Moving To New Record

Jun 26, 2014

I have a tab control with a Counsellor Training tab on it inmy form frmCounsellors. The issue I am having is that when I select a training type from the drop down in the sub form on the tab control on the counsellor training tab and then go to a new record of the main form, not on the sub form, the training type I selected on the form stays the same. If I change it on the second record, it stays at whatever I changed it to, even if I return to the first record it stays at what I changed it to as well.

How do I get it to stay with the counsellor and have it zero out for a new counsellor and it to allow me to enter something different for the new counsellor then save it for that counsellor?I just realised, I am having the same issue with the location combo box but I am sure I could apply a fix to both boxes if I knew one.

View 3 Replies View Related

Change Color Of Record Selector

May 11, 2006

I set the white background color. But, the record selector is grey color. Can I change the white color of the record selector bar?

View 1 Replies View Related

Forms :: Find Current Record When Moving From One Form To Another

Aug 7, 2013

Lets say,

Form A has fields: ID, LN and FN

ID LN FN
1 A F
2 B G
3 C H
4 D I
5 E J

Form B has fields: ID, LN and TR

ID LN TR
1 A Y
2 B N
3 C Y
4 D Y
5 E N

I would like to be able to switch between these two forms and the form automatically set focus to the record that I was on the form prior. Meaning if I am on record 3 on Form A and navigate to Form B, I would like to automatically set focus to record 3. Is this possible?

A possible issue after this gets sorted out is what happens if with the same scenario above record 3 does not exits? is it possible in that instance to simply requery the form?

View 11 Replies View Related

Record Selector In 2007 - One Click At A Time

Mar 5, 2008

Hi,
In Access 2007, I don't seem to be able to scan through a few records by holding down the advance record arrow in tables liked I used to?!
Am I missing something here, it worked in the same way in all other versions, the same as if you use the mouse wheel, it should run through each record in turn.

Is there a way to change this? I've been through all the settings I can think of...

Thanks guys

Matt

View 3 Replies View Related

How To Disable Back Button Of Record Selector

Aug 17, 2005

How can i disable back button of record selector, i dont want my user to fiddle with the data which is already entered.

View 3 Replies View Related

Hide Record Selector In Datasheet View

May 25, 2006

Hi
Can anyone confirm (or otherwise) that you can't set the record selector property to 'no' in a datasheet view form? (well, you can set it to 'no' but it seems to have no effect)

cheers
Neil

View 1 Replies View Related

Forms :: Creating Required Field In A Form Before Moving To Next Record

Feb 5, 2014

I have created a Form based from a Table. On one of the fields, I need to be required inside the Form before moving to the next record of that form. I can not make the required field in the table, because I have to append information day to day.

Also, the required field is a combo box option that is limit to the list.

What kind of Code I can do inside the form of the specific field to make it required before clicking onto the next record. It does not matter if the processor closes out of the form before updating, only if moving to the next record.

View 5 Replies View Related

Forms :: Highlight Unbound Subform Record That Matches Other Subform Record

Jan 22, 2014

I have two unbound unlinked subforms residing on a 3rd unbound main form. When I enter the current record on Subform1 I would like the matching record(s) on Subform2 to be highlighted or otherwise formatted. I can get this to work for only the first record on subform2 due to the way I have my code setup on Subform1:

Code:
Private Sub Accounting_Unit_Enter()
'find where AUs match. only works for first Subform2 record
If Me.[Accounting Unit] = Forms!MainForm.[Subform2]!AccountingUnit Then
msgbox "Match"
End If
End Sub

My thought was that I needed to reference the Recordset of Subform2 and search for all AccountingUnits that match the current AccountingUnit of Subform1,

View 6 Replies View Related

Forms :: Selecting Record In Parent Subform From Child Continuous Subform

Jan 26, 2014

I have two subforms on a main form. Both use similar queries and nearly the same set of records and PK. The first subform is for data entry and the 2nd subform is a continuous form that lists the entries in order that are made from the 1st Subform. (for entering in vacation days and appointments)

The continuous form cannot be edited, it is to be a list for viewing the information only.

I have an edit button next to each record on the continuous form. When the button is clicked, I want it to take the 1st subform to that specific record as well (same PK), so the information can be edited there.

I cannot figure out how to get the 1st subform to go to the record on the continuous form when the button next to that record is clicked on the continuous form.

I tried the DoCmdSearch for record and just keep getting object is not open errors.

View 2 Replies View Related

Moving Around A Subform

Dec 3, 2005

Greetings,

I have a subform where I can edit data and I have the following code;


Public Sub GotoNewRecord()

If Me.sumtransvolume = me.TotalLitres Then
Me.LabOpNumber.SetFocus
Else
DoCmd.GoToRecord , , acNext
End If

what occurs is that focus moves to a new record not the next record.

I am puzzles by this? Any clues how to fix this and get the control moving to the next record (some subform has 10-15 records)


rbinder

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved