building forms

[tmadrid3]

I am building a database from scratch. It should be simple because I want people to fill in the form even if they have never used access

On the form how do I set it up so that the entry for "Location" and "Date" populate from a table that I created. the reason I want it to populate is because I am a contractor for my city "Albuquerque" and when I put entires on the form I am only going to have Albuquerque entiries...but when some one else enters their list they will be in a different city and they will only have entiries for their city.

I have a table for all the event locations and the date they occur.
I have a different table that the form will populate?



Help
First time building a database, but I have worked with an already existing database and I know there are great ways to get this to work

[June7]

User needs to provide the location info. This can be part of some kind of login procedure. User identifies location when they open the db and code saves this value and then uses it when records are created, also use it to filter existing records. Login procedure is a common topic in forum. Search here or on web.

Or you can hard code a location into the database before you hand over to user.

The point is, Access can't read minds. If you want records to auto-populate, have to tell Access with what.

Why would date come from a table?

[tmadrid3]

Great!
Login sounds like a good option

Date is important because we are entering names of students who attend an event, only happens 1 time per month in different cities on different dates.

So I would enter data for Albuquerque on the following dates 10/23/2013. 11/20/2013, etc
and another person would enter Santa Fe data on the different dates, 10/24/2013, 11/21/2013, etc
Data would be similar such as Name, grade, teacher, school, etc

[June7]

If you have a table of these events, then could just enter the ID of that event record into the Registration table. Select the event in a combobox. Then code behind combobox can set DefaultValue property which will then populate subsequent records in the session with the value. No 'login' required.

[tmadrid3]

I am reading up on login forms, maybe that is too much for what I want
Is there a way I can make the text box remember what I put in last, for example I enter my "city" and "date" in the field and all the other fields...then I go to the next for and enter "c" and it automatically populates "city"

This is what excel does when you enter the same text in the next cell, it remembers what you had already entered and instead of you typing out the whole city name you can put the 1st letter and then select it

OR I could do this
I have a table with a list of 5 cities, can my form have a drop down list of those five cities so all I have to do is just select from that drop down?

[June7]

See my previous post, which I was typing and posted just before you posted.

[tmadrid3]

Sounds exactly like what I want to do (after deciding the login is too much).

Can you break this down for me a little more so I can figure it out?

[June7]

Form in design view, create combobox, give it a meaningful name like cbxLocation, with the combobox selected, on the Properties Sheet Event tab > BeforeUpdate event, click the ellipses (...) to open the VBA editor, type code in the procedure.

Me.cbxLocation.DefaultValue = Me.cbxLocation