Using form to enter data to a field

P

Prismaddict

The end result I'm looking for is to have a report with a list of names going
down on the left side and sequential dates across the top. I want to be able
to put selectable data into the given "mailbox". I have tables with names and
I have tables with dates and I have a table with a "status code" that will go
into the location of the paticular name on the particular date. What I want
is to be able to use a pull down to select the name and I already have a
calander generator that selects the date and then using a list or option box
place the "status" to that location. I can create a table that has a record
for each date and create a column for each name and forms and reports that
all specify exact locations but that seems very redundant. Can you have a
record by date and use "nameID" for the column? Or how do I do what I'm
trying to do but can't put it into words that help files understand. tia
btw caution extreme newby
 
G

Golfinray

You would want to use a form, not a report. A report is only for viewing or
printing data, not data input. It sounds to me like you may need a crosstab
query to properly display your data. As far as a pull down menu, you would
want to use a combo box and have in it the records you want to select.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top