Recent content by Mongooseman

I tried adding a requery call, but it effected no change. The list box is requeried automatically when Current is called from the form. I'm fairly certain the problem is that current is called before the Recordset moves. If I move from Resistor to Capacitor, for instance, strName is assigned...

Thank you for the reply. I should have clarified, that was just pseudo-code. The actual code looks like this: Public Sub populateRDM() Dim strSQL As String Dim strPart As String strPart = Me.Recordset.Fields("name").Value strSQL = "SELECT tblRDM_Numbers.part...

I have a list box on a form, and I want to change the list box's Rowsource property every time the current record changes. I created a sub called populate() that builds a SQL statement and assigns it to the Rowsource property. The SQL looks like this: SELECT RDM_No, part FROM RDM_Numbers WHERE...

Earlier this summer I was tasked with fixing a database used by the purchasing department where I work. I didn't know a lot about databases, but I learned pretty quickly. The tables--which were horrendous--are now normalized, but I'm having trouble getting data into them. My workplace still...