Solved Add new record from list box

[theinviter]

Dears;
I have created a form and subform to track stocks movement.
so in subform there is list box if items, once user double click on , it copy the data to new record in subform.
but i want the below:
1- Field Number to be updated with serial Number starting from 1.
2- Record count show number of record in current subform.
3- when double click on each items, add to new record without duplicate in current subform.


can you please advice me how to do it.
file attached

thanks

 

[jdraw]

A few comments, observations .
-recommend you provide a description of your business using the who, what, when, where, how much and how often to assist you and readers going forward. You may want to describe "a day in our business" to show how the business works or what the business processes are.

-suggest you work on the tables and relationships to get all pieces tied together in support of your business.

-recommend you set referential integrity on tables/relationships

-who are the vendors and clients; what/where are Orders recorded/stored

-provide explicit instructions to replicate an issue, or to invoke a process

 

[arnelgp]

1. First of all I modified [Order Request Form] table and removed
[Description] and [Unit of Measure (UoM)] fields, since this
two fields can be retrieved when we create a Query Joining
[Order Request Form] and [Master_List] tables.

2. Next I created a Querys to show the 2 fields and used the
query as RecordSource of your subform.

here is your db for you to test.

and as per your request,
1. done
2. done
3. done

 

[theinviter]

th

1. First of all I modified [Order Request Form] table and removed
[Description] and [Unit of Measure (UoM)] fields, since this
two fields can be retrieved when we create a Query Joining
[Order Request Form] and [Master_List] tables.

2. Next I created a Querys to show the 2 fields and used the
query as RecordSource of your subform.

here is your db for you to test.

and as per your request,
1. done
2. done
3. done

thanks you sir, really appreciate your support.

 

[theinviter]

1. First of all I modified [Order Request Form] table and removed
[Description] and [Unit of Measure (UoM)] fields, since this
two fields can be retrieved when we create a Query Joining
[Order Request Form] and [Master_List] tables.

2. Next I created a Querys to show the 2 fields and used the
query as RecordSource of your subform.

here is your db for you to test.

and as per your request,
1. done
2. done
3. done

thanks, but can you also apply this to Receive Date form, so the user will not be able to add any record before adding receive date.

 

[arnelgp]

here you test the Receive_Date form.