I need to use the same item - But how?

[FaurKris]

Okay, I have a form and it reads the following from a query:
SUP, FIS, DAY, TIME.

On the report, I need to print out multiples of these categories. For example,

SUP, FIS, DAY, TIME
SUP, FIS, DAY, TIME
etc.

I dont want to just create new tables or queries, since the form also allows me to edit or add information to the table for each category.

I could have as many as 20 line items which need to all read from the same table/query, but individually. This way, I can update, for example, SUP1 AND SUP5 on the same form.

I am BRAND NEW to Access, so my understanding of the VB involved is weak at best.

Can I even do what I am looking to do??

[patjones]

I'm not entirely clear on what you're trying to do. Generally, forms are used to display one record at a time (although this is not always the case). So when we talk about displaying your columns SUP, FIS, DATE, TIME...we usually think in terms of displaying those for a single record from the underlying recordsource.

I could have as many as 20 line items which need to all read from the same table/query, but individually. This way, I can update, for example, SUP1 AND SUP5 on the same form.

This is what you need to clarify. What are SUP1 and SUP5?

Reports are usually where you display lots of records at one time.

Pat

[FaurKris]

Yeah, I figured that forms are geared toward displaying just one record..... But there has to be a way to use a single form for multiple records....? Even multiples of the same...

SUP1 and SUP5 was just an example to say that I want to use "SUP" from the field list to display name 1 and name 5 from my column "SUP" in the table. And then of course, their respective row information...

I am looking to use the report to print what I either find, add or edit from the form.

[patjones]

OK, I read your other post and it is clearer now what you're trying to do.

What Jim says about continuous forms is something you should look into, as it might be a way for you to accomplish your objective.

There are a couple other methods. Access has something called a "list box" control, which allows you to display several records at once (in your case, multiple SUPs), then upon choosing something from the list box, the remainder of the record details populate in text boxes on the rest of the form (FIS, DATE, TIME, etc.)

Another possibility is the subform, which is basically a form embedded within a form, and which I believe can be made to perform a function similar to the list box.

Pat

[FaurKris]

OK, I read your other post and it is clearer now what you're trying to do.

What Jim says about continuous forms is something you should look into, as it might be a way for you to accomplish your objective.

There are a couple other methods. Access has something called a "list box" control, which allows you to display several records at once (in your case, multiple SUPs), then upon choosing something from the list box, the remainder of the record details populate in text boxes on the rest of the form (FIS, DATE, TIME, etc.)

Another possibility is the subform, which is basically a form embedded within a form, and which I believe can be made to perform a function similar to the list box.

Pat

Okay, thanks.

The easiest thing for me to do is the idea of the list box. I added it for SUP, and it did update all the other text boxes like you said it would. I made the form Continuous as well. When I scroll in the second list box, the forst does not change. But after I make my second selection, the first set of text boxes change.....

Is there a command or selection I need to keep each SUP box (and respective boxes) individual so they do not change?

[patjones]

Okay, thanks.

The easiest thing for me to do is the idea of the list box. I added it for SUP, and it did update all the other text boxes like you said it would. I made the form Continuous as well. When I scroll in the second list box, the forst does not change. But after I make my second selection, the first set of text boxes change.....

Is there a command or selection I need to keep each SUP box (and respective boxes) individual so they do not change?

If you are going to take the list box approach, I don't think the form needs to be made continuous...