Is it possible to add a record in this way?

[Jeffrey K. Ries]

I have been working on my first substantial Access database for a while now.
I have many, many things working just the way I want them. Now I get to the
point of wanting to add a record and I see through searches here and through
help files that the best way to do this is to have the text boxes and combo
boxes linked to the table I want the record added to. However when I do
this about half of my database either stops working or goes haywire.

What I want to know is this: Can I have a command button look at the
information in several unbound text boxes or combo boxes and then add a
record to a table with the information gathered? I would also need the
reverse to work - If I select a record in the subform which displays the
table I need the info to fill the text and combo boxes.

If this is possible can someone please point me in the right direction?

Thank you,
Jeffrey K. Ries

 

[Bruce]

Are you saying you want to combine the contents of several
unbound combo boxes into a single field in the table? If
so, you should probably reconsider. That task would be
better suited to a query. Having said that, it can be
done, but I think that more details of your project are
needed. For instance, are you using the form to search
for records as well as add and edit them? How does the
subform fit in? What does the database do, and how is it
structured?

 

[Jeffrey K. Ries]

Yes, that is exactly what I am attempting to do.

The form I am creating is for a timesheet, one that everyone in my office
can use and get reports of time spent on particulat projects or by
particular users. The form is setup with all of the combo and text boxes on
one side and the subform on the other displaying all table entries for that
day for that user. Filling the controls and clicking submit should add the
entry to the subform. Likewise, selecting an entry in the subform should
fill it into the controls for possible editing. I am using one master form
with a single subform (so far - I will probably need to create a subform for
each day of the week) and a single master table for all records. For now I
have all info in one file, however I plan to split it into two files (one
for the database and one for the forms) once I get it working correctly.

Obviously, by the location of my post you can see that I am still fairly new
to this program. Do you believe that what I am attempting is possible? Do
you still believe that a query is the answer to my dilema?

Thank you for any help you can give me,
Jeffrey K. Ries