Access Continuous Subform Data Entry Only
You're not using the continuous form correctly. It is not a grid like Excel, but rather (like datasheet) designed for showing BOUND data, meaning there is a Form.RecordSource, and all controls have a ControlSource.
Is it possible for you to set aside VBA for a moment and create a query that can be the recordsource for the subform? Maybe something like: select * from someTable where Reconciled=False;
-Tom.
Microsoft Access MVP
Phoenix, AZ
Was this reply helpful?
The subform has a record source, and I use this record source to identify what data I want to populate my comboboxes with. My problem is that it only does so for the first record. here is a screen cap of my form:
The sub-subform is where I am having trouble. the comboboxes are populated using the textbox's which are bound. I want this to happen on a per row basis. In the VBA I do thus (which again works for the first row):
Dim con As Control
Dim q As String
For Each con In Me.Controls
If (TypeName(con) = "Combobox" And con.name <> "cbx_WBS_Mapping") Then
q = "SELECT DISTINCT " & Replace(con.name, "cbx_", "") & " " & _
"FROM staging_tbl_LineItems " & _
"WHERE S_Details_ID IN(" & Me.txt_Details_IDs & ") " & _
"AND Upstream_LineItem_Name = '" & Me.txt_Contractor_ListItem & "'"
With con
.RowSource = q
End With
con = con.ItemData(0)
End If
Next con
The RecordSet for the sub-subform is set at the master form level and is dictated by the dropdown found there. Everything else works as I want it to... just not the continuous form...
Was this reply helpful?
The comboboxes I see are all unbound (have no ControlSource). That's going to cause the problem I outlined.
For the moment setting the Rowsource of the comboboxes is besides the point (but it may later cause secondary issues).
-Tom.
Microsoft Access MVP
Phoenix, AZ
Was this reply helpful?
but I don't want/need a control source. that binds the data to the back end itself, not the goal here. Even if it was, I am trying to group each field represented by a combobox on the texboxes values. Can such a grouping be done? I thought to do so with the RecordSet, but I know that each record gets a line in a continuous form... which is not what I was trying to do....
Was this reply helpful?
Sometimes one plays the fool...
Learning experience for those to follow. It turns out that in a continuous form there is no way to use unbound controls because the rows are not treated as instances (coming from a web dev background I assumed they where), instead it is just redrawn and populated with bound data.... so unbound controls are just copied. I'll have to figure out a different way to do what I want.
Thanks Tom for trying to help.
2 people found this reply helpful
·
Was this reply helpful?
Source: https://answers.microsoft.com/en-us/msoffice/forum/all/continuous-subform-unbound-control-to-pull-data/a535f512-c157-4e96-a9ac-a3f68d006bbc
0 Response to "Access Continuous Subform Data Entry Only"
Post a Comment