Form field control

Hi
I create a form contain a subform for data entry.
While I enter data in the main form then while move the cursor to subform field form data entry data entered in the main form disappeared.
Would you please advice how to change the setting to prevent this.
Do not want the data entered in the main form disappear while the cursor moved to subform field.
Thanks
alam747Asked:
Who is Participating?
 
als315Commented:
Test this sample. Real ID for DM ID was added. DM ID was removed from all tables except Memo.
Supplier is possible to add (with your old event) and edit address. Customec can be done in the same manner.
Test-memo.mdb
0
 
alam747Author Commented:
The form moved to the next record while I moved cursor to the subform .
0
 
als315Commented:
Could you upload your db with sample data?
Check all events on your main form and subform - may be they are wrong.
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
alam747Author Commented:
Would you please check my access db and if possible modifiy it to perform the following;

1 ) when open Debit Memo Data form it will display the blank field for data entry to the Debit Memo Data Input table and in DM Number field it will display auto increment Number for example if the previious record is DM-100 it will display DM-101. All other field will be empty.
2 ) Supplier Name combo box I want to link with tblSupplier(currently not linked) and when chose a supplier name from the combo box list it will display the supplier address in the Supplier Address on the form(below the Supplier Name ) and user can add new Supplier Name and address which will be saved to tblSupplier.
3 ) Same for Customer Name and Customer Address field also.
4) Subform releted one to many relationship. Multiple record can be added to tblDebit Memo Item Master in one DM Number.
5) After data input done user can print the report of the current displayed DM Number by choosing print botton.(which is now inactive)
6) Or after data input done user can choose the DM Number to print a report of specific DM number from the main switchboard form.
7) for section number and Account rep combo box user can add new data in the combo box list which is not in the current list. whatever choosen/added will add to the tblDebit Memo.
Thanks in advace for your co-operation and understanding.


Test-memo.mdb
0
 
als315Commented:
@alam747:
Here are some rules for uploaded DB's:
1. Rempve all sencitive information - OK
2. Remove all lockings (hide elements, passwords etc.) - not OK
3. Compact and repair DB - not OK

As I can see you have wrong tables structure. You should store references to tables, but not values. Try not to use lists.
Are you sure, main form data are disappeared? I've never got it. May be subform data are disappearing? Described behaviour is only when you are changing DM number on your form, but it is expected. Your main form and subform are joined by this field. If entered value is missing on your subform source, subform will be blank.
0
 
alam747Author Commented:
Hi
Thanks a lot for your advice.
I removed the password and attach the db. Would you please review and make the change where necessary to reach the goal as simple way as possible send it back to me.
Thanks in advace for your co-operation and understanding.
Thanks
Test-memo.mdb
0
 
als315Commented:
Can you explain me:
1. What is DM number and why it is stored in tables tblCustomer, tblSupplier and all others
2. What is stored in tables tblDebit Memo and tblDebit Memo Item Master
3. What is Item (ItemNo and Description)
4. Have you tested Norhwind demo DB?
4. What you want to get and how it is related to other question: http://www.experts-exchange.com/Microsoft/Applications/Q_26981307.html
0
 
alam747Author Commented:
DM number I used as a link to other table, later I can see preview the record using this number it can be other field too.
If you can advice or modify the combo box supplier name and customer name the way that I can enter new data on table tblSupplier and while I choose a supplier name it will display the supplier address in the supplier address field in the form , first it will be empty allowed me to enter new data to supplier name and address later I can choose from the supplier once added or allow me to new record if the one not exist in the supplier table.
Please ignore all other question I had before. just do the one and send me back the modified db if possible, as easy way as possible.

thanks
0
 
alam747Author Commented:
Thanks a lot for your advice, it helps, I will modify customer combo as you adviced.
Would you please advice how to add restriction for printing the report file. Any user can preview the report but need password to print out the report. How can I add this criteria in the report print/preview.

Thanks
0
 
als315Commented:
Sorry, due to experts-exchange rules, it should be asked in a separate question.
0
 
alam747Author Commented:
I am still working on it.
0
 
alam747Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.