[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Form field control

Posted on 2011-04-26
13
Medium Priority
?
364 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:alam747
  • 7
  • 5
12 Comments
 

Author Comment

by:alam747
ID: 35471633
The form moved to the next record while I moved cursor to the subform .
0
 
LVL 40

Expert Comment

by:als315
ID: 35474933
Could you upload your db with sample data?
Check all events on your main form and subform - may be they are wrong.
0
 

Author Comment

by:alam747
ID: 35482570
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 40

Expert Comment

by:als315
ID: 35482854
@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
 

Author Comment

by:alam747
ID: 35486300
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
 
LVL 40

Expert Comment

by:als315
ID: 35489255
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
 

Author Comment

by:alam747
ID: 35490245
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
 
LVL 40

Accepted Solution

by:
als315 earned 2000 total points
ID: 35490481
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
 

Author Comment

by:alam747
ID: 35502617
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
 
LVL 40

Expert Comment

by:als315
ID: 35502790
Sorry, due to experts-exchange rules, it should be asked in a separate question.
0
 

Author Comment

by:alam747
ID: 35700415
I am still working on it.
0
 

Author Closing Comment

by:alam747
ID: 36101780
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question