Form not feeding to Table

  • Thread starter alhindson via AccessMonster.com
  • Start date
A

alhindson via AccessMonster.com

Hello-
I have a continuous form based on an underlying table that contains date,
unit #, type, and yes/no check boxes. I've done it as "continuous" so we can
see all 25 types on one form and the user will click the check boxes that
correspond to the "type" they are interested in.
My problem is, at the top of the form I have a Date field and Unit field.
The user can choose these fields and it will automatically populate to each
25 lines type on the continuous form (trying to save the user time so they
don't have to enter the date and unit with each of the 25 lines on the
continuous form). I've got the date to auto fill each line on the form--but
for some reason it's not feeding that information to the underlying table?
Not sure what I'm doing wrong?

Any thoughts?
 
L

Linq Adams via AccessMonster.com

The first obvious question is

Is the textbox on the form bound to a field in the underlying table?

The next obvious question is

Where /how are you assigning this value to the texboxes?
 
A

alhindson via AccessMonster.com

It's set up so the boxes on the continuos form are bound to a field in the
underlying table [Date], [Unit]....but the continuous form has 20+ lines and
I don't want the user to have to fill in the date & unit for each line...I
was hoping there was a way to put a box at the top of the form for them to
enter the date and unit (one time) then this would filter down to each of the
[Date] & [Unit] boxes on each of the continuous forms. When I get the top
box to filter down it does put the Date & Unit in each box on the forms but
it doesn't fill this date & unit back into all the lines in the underlying
table???

does this make any sense?
 

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