Search results

Sorry I am at a lost at this point . . .

I read the article By Ken Gentz and am now really confused about why this doesn't work. This is an adp not an mdb so according to his statement my forms should be working. Here is his statement: (In an Access Data Project -- an .ADP file, using SQL Server or MSDE as its data source -- Access...

Hey, you are right. The msgbox did return the correct RegItemID so maybe it is the ADO that is not working correctly. Unfortunately I can not switch to DAO code so I will continue my search for a solution unless you have any other suggestions. Thanks for the help!!!!

dbo is the database owner. Are you still creating the select statement in code or did you create a view or stored procedure for the record source.

I guess my question would be though why can I pass in a hard coded value but can't get the value of RegItemID from the subform using ADO on the popup form. If the issue was with the ADO code on the popup form wouldn't the hard coded value break as well . . . oh maybe not.

Hey maybe you are onto something here. Yea the popup form as the following code: If Not IsNull(Me.OpenArgs) Then Dim RS As ADODB.Recordset Set RS = Me.Recordset.Clone RS.Find "[ReqItemID] = " & Me.OpenArgs If RS.EOF = False Then Me.Bookmark = RS.Bookmark End If...

Grab . . . if I hard code a value for example DoCmd.OpenForm stDocName, , , , , , "2" Then the popup form will open to the record ReqItemID = 2.

Nope, still won't grab the value in the field.

OK I still am not able to capture the field value. Here is the code Private Sub ckAltShippingAddr_Click() Dim stDocName As String stDocName = "frmAltShippingAddr" If Me.ckAltShippingAddr = True Then 'DoCmd.OpenForm stDocName, , , , , , "[ReqItemID]=" & Me![ReqItemID] DoCmd.OpenForm...

not sure if this was a typo in your post Me.RecordSource = "dbs.rstSubform" should be Me.RecordSource = "dbo.rstSubform" I am not sure if this will solve your problem. I suggested it because I sometimes have issues with certain users being able to access the sql server and the dbo qualifier...

Oops . . . sorry about the ADO references. I have been working on a similar bit of code using recordset.clone for the last day or so and read the DAO references and ADO.

Dim RS As ADODB.Recordset

I have a continuous subform in which a user picks a value from a combo box (cboField1). This value filters a list for another combo box (cboField2). In turn, when the user picks a value from cboField2, three other text fields get populated with data. Everything works great until a user goes...

Try Set rs = Me.Recordset.Clone

If you are connecting to a SQL backend then you need Me.RecordSource = "dbo.rstsubform"

Is this an mdb or adp? Parameter suggests an adp . . . that is why I ask.

Field ReqItemID is a text box on a subform. stDocName form doesn't have a value in OpenArgs. If I type in a value, e.g., DoCmd.OpenForm stDocName, , , , , , "2" The second form opens to the correct record. As soon as I try to capture the value . . . . OpenArgs = 0 and the second form...

It is not grabbing the value in the field. Any suggestions why?

How do you pass a field value as an OpenArgs For example, I have a field on my form called ReqItemID I tried DoCmd.OpenForm stDocName, , , , , , ReqItemID and DoCmd.OpenForm stDocName, , , , , , Me!ReqItemID and DoCmd.OpenForm stDocName, , , , , , "[ReqItemID] = " & Me![ReqItemID"

Here is the answer: http://support.microsoft.com/default.aspx?kbid=304181