Search results

So this is the question that begs to be asked... Why would the same program behave differently on two different systems? Why if we are both editing the code in the same place and in the same fashion would one see one set of records and the other a more complete set?

Well I'm not necessarily happy to hear that but it is what I needed to hear. Let me do some more noodling to see what I can see.

Bob, please note post #13 in this thread where I do indeed add that statement back to the code. In that try I added the statement to the end of the Form_Load yet even when I move it to the beginning of the cmdSearch_Click as you advised do I get the same result. When the form loads with coded...

Here's another interesting observation... .cmdNavGotoFirst.Visible = False .cmdNavGotoLast.Visible = False .cmdNavGotoNext.Visible = False .cmdNavGotoPrev.Visible = False .lblRecordNo.Visible = False .sfMarkSold.Form.RecordSource =...

Bob... Open frmMarkSold. Use combo to select item. To select a different item click Search. Rinse and repeat. Note: The Search button does not reassign the recordsource back to original. Once this works properly the subform will not be visible until after the user selects the item.

strSQL ... nope :confused:

smile... Recordsource not a field. Your code changed to... Forms!frmMarkSold!sfMarkSold.Form.RecordSource = SQL ... and still does not work.

Nope... Code assignment now in After Update with same result. :confused:

Private Sub cboSearch_Change() On Error GoTo Err_cboSearch_Change Dim db As Database Dim rst As DAO.Recordset Dim SQL As String SQL = "SELECT tblAuctions.AucID, tblAuctions.DateListed, tblAuctions.DateClosed...

OK, I'm going to close this thread and thank all who have offered their thoughts and comments. With what has been said and the new knowledge that I gained by watching a YouTube video or two I now have a much clearer understanding of subforms and at least conceptually I know how I can proceed...

David, thank you for your reply. But before I read, reread, and think about what you have said let me be clear. The datasheet subform is not where I want to edit. I could care less whether it is bound, unbound, live, or otherwise. It's simply nice to see the complete set of records of which the...

This is the query on which the form was bound... SELECT tblAuctions.DateListed, tblAuctions.DateClosed, tblAuctions.Qty, tblAuctions.Bid_Price, tblAuctions.BO_Price, tblAuctions.Duration, tblAuctions.Deposit, tblAuctions.AH_Cut, tblAuctions.Status, tblAuctions.Notes, tblItems.Item...

And indeed did cause the conflict. Interestingly enough that is how the wizard setup the form yet I will say it did not know that I was going to update the records using a recordset. And so this discussion end and returns us to our original question of a single record in the main along with...

There was no code in the subform. That said, the subform was simply a complete listing of the recordset of which the top of the form showed only the current record within that set. Successful addition... I could physically see the record with changes when i open the physical table or query...

No, the record addition was successful yet the cursor left in the subform of the changed record balked after the program updated the record. It's not like I physically put the cursor there. The subform was bound to the top bound form record and moved with the navigation. Tables/joins...

[RESOLVED] Bound/Unbound... Subform... Write Conflict... Conceptual Help I'm unsure whether this belongs in this Forms thread or in Theory & Practice. Based on the nature of the discussion I chose here. I write to start a discussion for conceptual help. After returning to Access after many...

Thank you gentlemen. Your inputs have helped and are most appreciated.

Option Compare Database Option Explicit 'These are used as rollbacks 'Called by cmdCancel_click() 'Updated by Form_Current Static RBBidPrice As Single Static RBBuyoutPrice As Single Static RBDeposit As Single Static RBAHCut As SingleI am experiencing strange editor behavior with and without the...