How to deal with field from a list box in a form (1 Viewer)

[Hema1]

I know at first that the level of my question does not compare to the extent of your experience, but excuse me because I am a beginner in learning Access.


There is a list box with the word above it
all test
--------
take data from table named
test_tbl

When you click on any item once, I want it to move to other list box with the word above it
patient tests

This list will send the data to the table named
test_order_tbl

I want all the data in the first table to be copey to the second table

There is a place for each field, like the example in the picture

and The opposite. means that if you click on any analysis, it will go back to its place

If the user chooses the same analysis twice, a message appears saying that the analysis has been selected previously

I also want to binding

id, code, vdate from reservation_tbl table

with
id,code,tdate from list box [selected_list]

Last thing seriously

I want the field patient price located in list box its name
selected_list
Collected in the field service_price

 

[Uncle Gizmo]

The purpose of this post is to bringing your question back up the list so that it gets another look. Looking through your posts it appears you have reposted a slightly different question and received an answer. If you have received a satisfactory answer elsewhere, then please mark this question as solved, or add a note to explain that the question is obsolete so that people don't waste their time answering a question you already have an answer to.

 

[mike60smart]

I know at first that the level of my question does not compare to the extent of your experience, but excuse me because I am a beginner in learning Access.


There is a list box with the word above it
all test
--------
take data from table named
test_tbl

When you click on any item once, I want it to move to other list box with the word above it
patient tests

This list will send the data to the table named
test_order_tbl

I want all the data in the first table to be copey to the second table

There is a place for each field, like the example in the picture

and The opposite. means that if you click on any analysis, it will go back to its place

If the user chooses the same analysis twice, a message appears saying that the analysis has been selected previously

I also want to binding

id, code, vdate from reservation_tbl table

with
id,code,tdate from list box [selected_list]

Last thing seriously

I want the field patient price located in list box its name
selected_list
Collected in the field service_price

You need to look again at normalisation of tables.

All of your tables are currently constructed in the wrong way.

You have no Referential integrity established between related tables.

You have fields created as Autonumber Data Type but not set the field to Primary Key.

I could go on but I think this is enough for you to rethink what process you are creating.