M
mylrob
What I'm trying to do is simple:
I have a single table in a SQL Server database that I want to link to via an
ADP.
I would like to display the table in a subform in order to view, edit and
add new data. In addition, I would like to have command buttons in the form
which allows me to display the table in different sort orders. (Note that
the subform is not linked to a control on the main form, the command buttons
are used only to change the way the table is displayed.)
Could someone provide me with code to do this? In addition, everytime I
display the table by setting the RecordObject in the subform properties, I
can display the data but I can't modify or add new data.
If a subform is not the proper control to do this, could you please indicate
which control would be more adequate.
Your help is appreciated.
Robert
I have a single table in a SQL Server database that I want to link to via an
ADP.
I would like to display the table in a subform in order to view, edit and
add new data. In addition, I would like to have command buttons in the form
which allows me to display the table in different sort orders. (Note that
the subform is not linked to a control on the main form, the command buttons
are used only to change the way the table is displayed.)
Could someone provide me with code to do this? In addition, everytime I
display the table by setting the RecordObject in the subform properties, I
can display the data but I can't modify or add new data.
If a subform is not the proper control to do this, could you please indicate
which control would be more adequate.
Your help is appreciated.
Robert