If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Recordsouce question
Can I change the recordsource of a form on the fly? In other words, I have
one table (a small one-to-one so I didn't split it) and I would like to have 3 maybe 4 queries off that one table. Then change the recordsouce of the form to query1, or query 2, etc, depending on what the user picks in a combo. The fields displayed on the form from each query would be the same. I know I might be able to do it with case statements, but is there an easier way? Thanks a bunch!!! -- Milton Purdy ACCESS State of Arkansas |
#2
|
|||
|
|||
Recordsouce question
"golfinray" wrote in message
news Can I change the recordsource of a form on the fly? Yes. In other words, I have one table (a small one-to-one so I didn't split it) and I would like to have 3 maybe 4 queries off that one table. Then change the recordsouce of the form to query1, or query 2, etc, depending on what the user picks in a combo. The fields displayed on the form from each query would be the same. I know I might be able to do it with case statements, but is there an easier way? You could set up your combo with two columns, one containing the display text for the user to pick, and the other containing the SQL statement (or query/table name) to be assigned to the form's RecordSource. Code in the combo's AfterUpdate event might look like this: '----- start of example code ------ Private Sub cboDataSource_AfterUpdate() Me.RecordSource = _ Me.cboDataSource.Column(1) & vbNullString End Sub '----- end of example code ------ -- Dirk Goldgar, MS Access MVP Access tips: www.datagnostics.com/tips.html (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|