Continuous Forms (1 Viewer)

[drpkrupa]

I have Continuous Forms which display all items for one part number. The main form Part Info with with this Continuous Forms with key feild called "Product_ID".

One part can have multiple items on sub Continuous Forms. I want to create way so user can add item in between two existing items.

Example:
Product Info - Master form
1 = Chassies
Item form- Continuous Forms
Product_ID, Item_Id, Desc
1, 100, Test1
1, 200, Test2
1, 101, Test3
1, 202, Test4

I want user to add another item in-between item id 200 and 101. How can i let user add new line in-between two existing line in Continuous Forms.

 

[namliam]

You cannot, adds always happen at the bottom.
You can "force" the added record in the proper place assuming you can do some kind of sorting... (order by)

 

[boblarson]

Just to expand on namliam's post -

Data in Access is not like Excel where you insert rows and such. You add data to the database, it is displayed how you have defined. If you want it in a certain order then you have to provide a way for Access to order it the way you want, whether it be by date added, alphabetically, or even in a custom sort order. But tables in Access are NOT stored in any particular order. It may APPEAR that they are but in reality they are not and so you have to impose order on them by using a QUERY. You can't rely on the ORDER BY in the table either because in reality that just applies an order to the VIEW you get when you "open" the table. You aren't really opening the table but are instead looking at a special type of QUERY which displays the data to you.

So, for ordering you must supply the way to order and you must use a query to view it in the order you want. And just as another note - in REPORTS you must use the SORTING AND GROUPING tool there because even query order by's in reports are not maintained or followed.