Form to organize records by todays date

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

I am trying to create a form that will organize my records by today’s date
and perform these functions below. I need the most help setting up the
tables, can you guide me.

Field1 : Drop down list with 6 different activities to choose from.

Field2: Default today’s date

Field3: enter Quality of experience (ranges from 1 to 10)

Field4: Drop down list with different times to choose from 5 min, 10 min, 15
min, 20 min, 25 min, 30 min

Field5: labeled completed, has a check box/ Yes or No

This is how I have my table is currently set up, but I am not able to get
the results I am looking for when I create the form

tblActivity --
ActivityID - Autonumber - primary key field
ActivityType -
ActionDate - DateTime datatype - default =Date()
Quality -
Duration -
Consistency -
 
What ain't you getting that you want?

What are you getting you do not want?

Post example and sample.
 
What ain't you getting that you want?

A drop down box with a list of activities to choose from. I was able to
install the drop down box on the form but I can’t get the list to display the
six different activities to choose from. (I am always using the same six
activities, should that effect the table design or is that okay? )

To get the form to display the six different activities I entered
tblActivity in design view and went to the ActivityType field. I clicked the
lookup tab and selected combo box. In the row source I entered
"Activity1";"Activity2";"Activity3";"Activity4";"Activity5";"Activitiy6"

But I still was unsuccessful which leads me to what I am getting that I
don't want.

What are you getting you do not want?

When I try to use the combo box on the new form I created from the updated
table a message box that says “The record source
"Activity1";"Activity2";"Activity3";"Activity4";"Activity5";"Activitiy6"
specified on this form does not exist. You misspelled the name, or it was
deleted or renamed in the current database, or it exists in a different
database.

In the Form or Report’s Design View, display the property sheet by clicking
the properties button, and then set the RecordSource property to an existing
table or query."

The spelling is correct as are the activities so I don’t understand why I am
getting this message. Please help if you can. Thank you!
 
Update: I got The combo box to display a drop down list now, but instead of
displaying the activity type a number is being displayed.
 
Never mind, back to the same problem again.

Teddy said:
Update: I got The combo box to display a drop down list now, but instead of
displaying the activity type a number is being displayed.
Click to expand...
 
Back
Top