Help!!!Same Table Two different Forms

[chris11590]

is there any way to have two subforms which are linked to the same table but each subform have, again, the same recordsource but on the first form display a few records and the 2nd subforms have the remaining records. the forms would display in datasheet view.


can anyone help with this

 

[khawar]

You can use say Top 10 records in first subform and others (excluding Top 10) in the second subform

Check the top statement in query help

 

[georgedwilkinson]

Not only can you do it, I do it regularly. Of course, both (all) of the subforms have a different filter on the query.

 

[chris11590]

i dont think this will help because the records are, i think, need to be sorted then filter. for example, i made need record number 1 and record number 20. it may not be necessary in the top 10.

any suggestions

chrissy. thank you all in advance

 

[georgedwilkinson]

Well, yeah, I have lots of suggestions, just not enough time to type them all.

What's wrong with Khawar's advice? Just use top (whatever) to display the first however many and in the second query, just exclude all records that were in the first section (hint: use SQL "NOT IN" is one way to exclude).

 

[chris11590]

Re: Help!!!Same Table Two different Forms(db attached)

Can you look at the example i have attached.

on the form object look at branchform2needtodividerecords. i have created a form based off query2 (both queries are the same), but the problem i encountered as I mentioned is the first three records need to be displayed into a seperated branch. Is there any easier way then you mentioned above. I am looking into cascasading boxes.

how do you do a criteria for a specific "branch" in the query???

or one query for each branch thats too long many many branches.

chrissy as alway thank u

 

[georgedwilkinson]

Hi Chrissy,

I'm in the middle of some alligators right now. I'll try to look later. I have this thread opened in a separate window (unless my computer crashes again).

 

[chris11590]

okie dokie thank you...i underdstand..

 

[chris11590]

this sample db is similar to what i am trying to accomplish. i have numerous branches but on this form there are 4, on the average there can be 8. each branch breakdowns into various group sector.

what i did was created queries with a SQL "where", which group the branches. the problem becomes i have to input 4 different parameters for the form to be form. (too much work and too complicated for the user).

give it a shot. four parameters are (no specific order) "planning", "fire, hazmat", and "incident commander and staff". (if a subform is blank after you input branch, it just simply because the the branch was not inputted correctly).

is there an easy way??? I am a amateur with SQL . this is my first "where" clause.

Chrissy