Automatic data loading (1 Viewer)

MikiA

New member
Local time
Today, 16:41
Joined
Sep 2, 2020
Messages
17
Hello,
I got stuck at the start.
I need to make an entry form looks like the picture.
Column A, with names, should be loaded each time the form is opened.
Data will be entered in other fields.
And all data should be stored to the table.

Does anyone have any idea how to do this ?
I mean, on wich way i can pull up data to the form
each time when i open the form ?
 

Attachments

  • 333.jpg
    333.jpg
    39 KB · Views: 92

bob fitz

AWF VIP
Local time
Today, 15:41
Joined
May 23, 2011
Messages
4,717
I need to make an entry form looks like the picture.
Try a form in "Continuous" view
Data will be entered in other fields.
And all data should be stored to the table.
Bind the form and the controls on it to a table/query and the controls to the fields in the table/query
 

MikiA

New member
Local time
Today, 16:41
Joined
Sep 2, 2020
Messages
17
I was create continuous form, bound text boxes to the table. Set form to data entry yes.
When i load form i got blank form.
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:41
Joined
Sep 21, 2011
Messages
14,056
I was create continuous form, bound text boxes to the table. Set form to data entry yes.
When i load form i got blank form.
Yes, that stupid option gets everyone. If it is set to Yes, you can only ADD new records. Set it to NO, then the records will appear and you can just add from the * on the navigation bar at the bottom of the form.
 

bob fitz

AWF VIP
Local time
Today, 15:41
Joined
May 23, 2011
Messages
4,717
By setting data entry to yes you will only be able to access records created since you opened the form. It opens at a new record.
 

MikiA

New member
Local time
Today, 16:41
Joined
Sep 2, 2020
Messages
17
I understand.
One more question.
Is it posible, when i set data entry to no, and when i open the form to get column A populated and rest field empty ?
 

Gasman

Enthusiastic Amateur
Local time
Today, 15:41
Joined
Sep 21, 2011
Messages
14,056
I understand.
One more question.
Is it posible, when i set data entry to no, and when i open the form to get column A populated and rest field empty ?
Yes, but you have to tell Access what is meant to go in there.?
 

Users who are viewing this thread

Top Bottom