leach613
Last Activity: Jun 7 '10, 05:54 PM
Joined: May 4 '10
Location:
-
Are you trying to filter or sort one combobox based on the choice of another? Do you actually have 1 table or a table for each product type? -
Thanks for the info, I certainly didn't want to delete any records in the table so thank goodness I couldn't figure it out.
EvyLeave a comment:
-
Well it seems like I got the first part of my question resolved but still could not get the second part resolve.
First part was to populate the comboBox with a recordset. Got that working. Second was to be able to update/delete/add the records in the recordset and have it reflect on the comboBox.
I have taken a different approach. After creating the recordset, I looped through them and used the .AddItem to add them...Leave a comment:
-
I don't understand why you would want to update that kind of info. When I need to see this kind of info I usually just make a report. What is there to update?
EvyLeave a comment:
-
On line 73, when was the recordset rstTotalDays created? Seems out of place when you are adding a record to rsttblTempPO.
EvyLeave a comment:
-
I defined it as a public recordset.
After they choose what Customer sent the payment from a combo box I have this in the afterupdate event.Code:Option Compare Database Option Explicit Public dbTrans as DAO.Database, rstInv as DAO.Recordset
...Code:Set dbTrans = CurrentDb Set rstInv = dbTrans.OpenRecordset("SELECT [InvNo], [DueDate], CCur([BalAmt]) as Payment, [InvAmt], [CustID], [Posting] FROM tblTransactionsLeave a comment:
-
That's the way I had it the first time I tried but I still get the same error.
EvyLeave a comment:
-
Thanks Linq for your reply but the whole purpose of populating the combo box with a recordset was to be able to manipulate the recordset and not the table. The table will be update in the end when the person clicks the post button.
I tried to update the recordset but I keep getting an error. Here is my code..
...Code:Dim strInv as string strInv = me.InvNo With rstInv .Index = "InvNo"Leave a comment:
-
Yes I would like to remove it from the combo box but since the combo box is populated by the recordset isn't that the same thing? Also don't I have to requery and won't that just bring in the same info I had to begin with.
I tried using removeitem but it said that the recordsourcetyp e had to be a value list to use.
So now what?
EvyLeave a comment:
-
Update, I just found out what I was missing.
I was using......Me.I nvNo.recordset = rstInv 'By the way, this recordset is declared as Public.
What I was missing was.....Set Me.InvNo.record erset = rstInv
This worked. Now I need to know how to remove item in the recordset or update a field in the recordset and then requery it to filter out the invoice.
I tried...Me.InvN o.RemoveItem (rstInv.Index)...Leave a comment:
-
How to populate a combobox with an updatable recordset?
First of all, I'm use Access 2003 but most of the people that will be using this database with be using Access 2002. I'm not sure if that will make much of a difference but anyways here is my question. Oh and I'm making an Accounts Receivable Database.
My main question is, can you populate a multi column comboBox by using a recordset?
I would like to choose a CustID in one comboBox and use afterupdate event to create...
No activity results to display
Leave a comment: