Search results

OK here is what I have so far . . . not sure if I am on the right track. Dim rst As Object Dim strCriteria As String Set rst = Me.Recordset.Clone strCriteria = "CheckItemID = " & Me!CheckItemID rst.FindFirst strCriteria Me.Bookmark = rst.Bookmark I am using ADO which is why I am using...

The event is on the after update on a combo box. The value that is choosen in the combo box needs to be saved and then the requery populates a bunch of additional fields on the form based on the value they choose in the combo box. Sorry should have mentioned this in my original post. Thanks!

I have a continuous subform in which I am having troubles keeping the focus on the current record that the user is on. For example, there are 3 records in the subform and the user changes record 2 or 3. The user is then taken back to record 1. I have used similar code on other forms and...

It doesn't sound like the same problem. All of the data is int. Another problem I am having on one of the combo boxes is that it won't let me set Limit To List = No if I have the first column which is the bound column width = 0. It keeps giving me an error: MS Access can't set the LimitToList...

I have a combo box on a subform that I would like to limit the user to the list. However, when I set Limit To List = Yes . . . the user can not type in a value if they know it even if it is in the list. The error message states: The text you entered isn't an item in the list. The text is in...

Pat, do you mean the code would not work with the code to turn off the scrolling or did you mean in general. Just wondering, because the code did work before I added the code to turn off the scrolling which why I do not understand why the cancel = True is a problem now on the other events...

I added the code referred to in the following article to turn off the mouse scrolling completely within Access. http://support.microsoft.com/default.aspx?scid=kb;en-us;278379&Product=acc2000 However, my problem now is that my other code which was working before is no longer working. For...

What is strange is that I am doing almost the same thing in another db using the same method of filtering to a specific record when the form loads and I am not having any issues.

On the search form the user can choose the ReqID from a combo box. The combo box is called cboReqID. On the load event of the form I have: Me.Filter = "ReqID=" & Forms!frmSearch!cboReqID Me.FilterOn = True

Yea, I thought of that also and tried it but it still goes to a new record.

I have a form which opens to a filtered record. Problem if the user deletes the record for some reason it goes to a new record. I created the delete button using the wizard and added a line to close the form.

Is there a way via code to "Send To Back" a textbox. I am setting the focus to a textbox so I can't make it invisible but I don't want it to show on the form.

The record source of the combo box is a stored procedure. The record source for the subform is also a stored procedure. The main form has a field on it called cboVendorID. The value from that field gets passed to an unbound field on the subform. The value in the unbound field is passed as a...

I have a subform with a combo box. On the after update event of the combo box I have: DoCmd.RunCommand acCmdSaveRecord Me.Requery The value in the combo box determines what data is populated in the other fields on the subform which is why I am saving the record and requering the data. The...

I have a subform where the default view is single form. On the after update event on my combo boxes I have the following code: rs = Forms!frmReq!sbfReqItems!txtReqItemID DoCmd.RunCommand acCmdSaveRecord Forms!frmReq!sbfReqItems.Requery Forms!frmReq!sbfReqItems!txtReqItemID.SetFocus...

That did it . . . thank you very much!!!

I tested it again and you are right it did add it as the value in the field. The problem is which I hadn't noticed before is once the value is added it goes to the next record. For example, if I am on record 1 and add a new value into the combo box . . . once I close the msgbox . . . the form...

I have a main form with a continuous subform. On each record on the subform the user can check a box which if true will open up a new form. The Subform is built on TableA and the popup form is built on TableB. The primary and foreign keys in both tables is called RegItemID. The problem is as...

dcx693 thanks for your help . . . but I gave up? The reason I am having to do this to begin with is to handle a bug in Access 2000 using an adp. I decided that I have spent 3-4 days beating my head against a wall and that is long enough. I redesigned the backend and split out the data being...

I think I changed it at one point because I was getting an error on that line and I found an example where it was Me.Recordset.Clone. I changed it back to Me.RecordsetClone and it still doesn't work. I am surfing the net for an answer as we speak. I found something that mention not being...