Hi Everyone,
I am not a programmer so my question might sound a bit dumb to all the professional people here but I'd really appreciate ya'lls input. Thanks in advance!!!
We have a table called Student which has a primary key "ID". I have this value show up in a textbox in one of the forms. When this ID is double clicked another form is supposed to open up with the funding information corresponding to that particular student ID. The data for the funding information comes from a linked table where the ID field goes by a different name "SFCRefNo". How can I pass the variable "ID" to the query which fetches the funding information.
I am not a programmer so my question might sound a bit dumb to all the professional people here but I'd really appreciate ya'lls input. Thanks in advance!!!
We have a table called Student which has a primary key "ID". I have this value show up in a textbox in one of the forms. When this ID is double clicked another form is supposed to open up with the funding information corresponding to that particular student ID. The data for the funding information comes from a linked table where the ID field goes by a different name "SFCRefNo". How can I pass the variable "ID" to the query which fetches the funding information.