Recent content by mRcooper

The reason i'm running several forms is because I'm breaking up an original big form into smaller ones...kind of like a suite of windows, each used for a different application, but relating to the same data. It works really well at the mo and is very quick! Although I can't add records...

My forms aren't bound, I have used the following code to change directly the recordset on the other forms... rsIS2Assembly.FindLast "[SerialNumber] = '" & SerialNumber & "'" If Not rsIS2Assembly.EOF Then Forms![fProductionBuildIS2_Assembly].Bookmark = rsIS2Assembly.Bookmark...

Hi, I currently have several forms open, each with their own recordset. One of my forms controls what record each form looks at...i.e syncing each form to a unique serial number. However, I cannot get my 'Add Record' button on my control form to jump all of the existing forms to the new record...

Hi, I would like to perform a 'Between date' function on a query, where the dates are variables. These dates are obtained from two other queries, qMinDate and qMaxDate, which are both 1 col, 1 field. How to I insert qMinDate/qMaxDate into the 'between' statement in the query?

It's ok actually, because i've figured out how to do it! I'm declaring a recordset from one form, which will control another.

I am trying to create a 'navigation' control form in Access that will allow me to scroll up and down my records, via SerialNumbers. However, when I do this I would like another form to update instantly. ie. if I go to a SerialNumber on my control bar form, I would like to automatically go that...