Z
Zulay
Good afternoon all:
In my database, the user can enter a new record by filling some
fields on a table I create in a data access page. That part is working
properly, I mean, I can enter information on the fields and the info is
saving on a table in the Access database. What I need to do is to retrieve
the information of a specific record (an specific row of the data base table)
in the same table of the data access page. I see the records added by the
navigation bar but I just need to see a specific record. The record should be
selected by a dropdownlist in which the user would have the opportunity to
select one of the entries of a certain field in the table.
I will give a more specific information. I have a
table with several colums that corresponds to each field that can be fill in
the data access page by the user. Two of those colums combine will let me see
a specific record: the part number and the change1 fields. I have a data
access page that has a submit command button (that should open the data
access page in the desire record) and 2 dropdownlists: PNList1 (which display
the list of part numbers in the table) and ChangeList1 (which display the
list of changes done to the part number specified in the previous
dropdownlist). The query says:
SELECT FormTable1.PartNumber, FormTable1.Change1
FROM FormTable1
WHERE (FormTable1.PartNumber=PNList1.value) and
(FormTable1.Change1=ChangeList1.value);
Can I run the query in a script when clicking the submit button in the data
access page where I choose the part number and change, and then open the data
access page that displays the records? I really do not know if this is
possible. I am really thankful for the help you can give me. If you have any
suggestion of how to do this, will be really appreciated.
In my database, the user can enter a new record by filling some
fields on a table I create in a data access page. That part is working
properly, I mean, I can enter information on the fields and the info is
saving on a table in the Access database. What I need to do is to retrieve
the information of a specific record (an specific row of the data base table)
in the same table of the data access page. I see the records added by the
navigation bar but I just need to see a specific record. The record should be
selected by a dropdownlist in which the user would have the opportunity to
select one of the entries of a certain field in the table.
I will give a more specific information. I have a
table with several colums that corresponds to each field that can be fill in
the data access page by the user. Two of those colums combine will let me see
a specific record: the part number and the change1 fields. I have a data
access page that has a submit command button (that should open the data
access page in the desire record) and 2 dropdownlists: PNList1 (which display
the list of part numbers in the table) and ChangeList1 (which display the
list of changes done to the part number specified in the previous
dropdownlist). The query says:
SELECT FormTable1.PartNumber, FormTable1.Change1
FROM FormTable1
WHERE (FormTable1.PartNumber=PNList1.value) and
(FormTable1.Change1=ChangeList1.value);
Can I run the query in a script when clicking the submit button in the data
access page where I choose the part number and change, and then open the data
access page that displays the records? I really do not know if this is
possible. I am really thankful for the help you can give me. If you have any
suggestion of how to do this, will be really appreciated.