Query for displyinga nd storing data on text change in form

[baijuep]

Sir, i am new in MS Access i had worked in asp.net. but now i want some help in access.
I have a small accessd database in which i have a form there is abarcode field when barcode is fired to that barcode filed a query should run to fetch the data of that particular person from table named MAIN and display in the fileds in the form and the entire data to be inserted into another table naned enterkot.
My table structure is as under

MAIN (Table)

id autonumber
No text
tank text
Name_ text
Barcode text

ENTERKOT (table)

id autonumber
mid number
No text
Tank text
Name_ text
Barcode text
Date_ datetime

When i open my form name enterkot there are all fields to enter data.
1. When i click my barcode and the barcode is eneterd in to barcode field.
2. On text chnage the data should pickup from table main and display in form
3. In form there is a field named date the date should be the computer date
4. After displying the data in form it should automatically stored in table ENTERKOT

please guide me i am new in access

 

[Uncle Gizmo]

>>>the entire data to be inserted into another table naned enterkot.<<<

This is not necessary? Please explain why you can't just use the main table with the extra fields added, "mid number" and "Date_ datetime"?

 

[baijuep]

In Table named MAIN i store the data of the members
No, Tank, Name_, Barcode

in ENTERKOT i store

Date, Barcode

This is used to ckeck how many times and when these people entered the premisis of the store.

so that when a person show the barcode in front of the scanner the barciode should store with date (barcode in barcode field and date in date field

 

[Uncle Gizmo]

Do you need to record when they leave?