Does anyone know if I can record a macro in Access. If the answer is no. I have a list box that is populated with hours logged on a project, from one table. The value selected, (on the form) is to be stored in another table. However, if I don't click or tab to said field (list box with hours...
Does anyone know if I can record a macro in Access. If the answer is no. I have a list box that is populated with hours logged on a project, from one table. The value selected, (on the form) is to be stored in another table. However, if I don't click or tab to said field (list box with hours...
Private Sub cboPlant_Change()
Dim dbs As Database
Dim rst As Recordset
Dim strSQL As String
Dim strPlant As String
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Plants")
strPlant = vbNullString
strSQL = vbNullString
Me.cboPlant.SetFocus
strPlant = Me.cboPlant.Text
strSQL =...
I have a combo box that is populated with numbers from a table where it is the primary key (Cost Center #'s). I was hoping that when the selection was made it would populate a text box for the cost center's name. I have been fooling around with recordsets, but I can't get it to work.
Please...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.