Access Forms only connecting through live SQL tables?

[alexsmith91]

Hi,

• Can I create forms which open sub forms based on the ID of a record selected, which in-turn open sub forms for the selected ID only while connecting to a live SQL table? No linking of tables, no pass-through queries. Only for reading the data, not writing.
• I understand that I need to capture the value of that id as "Me. ID". Store that value in the record set
• Open the subform, and then set the values of the subform with that record set?

Let me know if these are the high level steps that can be done.

[ranman256]

it's best to link the tables from sql, then ALL data is live.

connect the subform properties to the master form field: ID
LINK MASTER FIELDS = ID
LINK CHILD FIELDS = ID

then the subform will automically fill in the ID value.

[alexsmith91]

Like I mentioned, I wont be able to link the tables from SQL. Though I understand that is the best process.

it's best to link the tables from sql, then ALL data is live.

connect the subform properties to the master form field: ID
LINK MASTER FIELDS = ID
LINK CHILD FIELDS = ID

then the subform will automically fill in the ID value.

[Minty]

Like I mentioned, I wont be able to link the tables from SQL. Though I understand that is the best process.

This is going to sound a bit daft, but if you can't link to the tables how do you propose to get the data from them?

[alexsmith91]

I had read it somewhere that you can create a data connection with details about server/db name etc and then you can create a a recordset which would store the data from your sql.

This is going to sound a bit daft, but if you can't link to the tables how do you propose to get the data from them?

[ranman256]

same as linking tables. Same info, same tables.