Automatically adding/expanding new row in MS Access forms

[pritesharyan]

I am trying to build an invoice form in which the user has to select an item and when ever the item is selected from the combo box, a new blank row should be added at bottom as shown in the screen shot below.






I have seen that the Northwind sales database has done same thing but I don't know how to implement it.
As per my search, they have build form (below screen shot) and put it in Order Detail (Subform),
but what is the logic behind automatically adding of new row at last?

[rpeare]

if you're using a bound form as soon as you enter ANY value in a 'blank' record a new record should be displayed. There's no special code to get it to do it, it's the default behavior.

[pritesharyan]

Thank you so much for fast replying.
as i am beginner please what is bound form??
sorry if this is a silly question

[rpeare]

A bound form is a form that is based on a query or table as the RECORD SOURCE
an unbound form is a form that has no RECORD SOURCE and data manipulation is handled by code or queries.

[pritesharyan]

@rpeare
i have tried bound form but could't succeed.
does it only works in subform?
Download what i have tried

[June7]

Forms can be set as Single View, Datasheet View, Continuous View in the Default View property. You have the form set to Single View. Use Navigation Controls at bottom of form to move to new record row or change the view setting.

Have you studied an introductory tutorial book?

[pritesharyan]

@June7
I am not trying to just going to new record
when ever i add new record new combo for Test ID and Two new Text Box for TestName and TestAddress should be created respectively.
see the customer order form in my Question, whenever new Product selected from combo box new delete button,Combo for(product name), five Text Boxes for Quantity, Unit price, Discount, Total Price, Status will be created.
Please guide me.

[June7]

Not sure what you are asking for. Before creating forms and reports, need to get the data structure defined. The posted db has only one table.

The Northwind image shows a form/subform arrangement. What is it you don't understand about form/subform?

The new record row automatically displays with form in Datasheet or Continuous view. In Single View, click the navigation button at bottom of form to go to new record.

[pritesharyan]

@June7
See the below screen shot
Download Northwind sales web database for referance.

[June7]

This is normal behavior of form set for Datasheet view. If you want Quantity, UnitPrice, Discount, TotalPrice, Status 'columns' then create textboxes on form. Set DefaultValue property.

TotalPrice will have an expression in ControlSource to calculate: =[Quantity] * [UnitPrice]

UnitPrice can be automatically populated with an expression that references a column of the Product combobox: =[Product].[Column](1)

For multi-column combobox, review http://www.datapigtechnologies.com/f...combobox3.html

This is all very basic Access functionality.

[pritesharyan]

Thank you so much @june7
Here is what I Want to achieve and finally achieved
once again thank you so much @June7 and @rpeare