Go Back   Access World Forums > Microsoft Access Discussion > Forms

 
Reply
 
Thread Tools Rating: Thread Rating: 2 votes, 5.00 average. Display Modes
Old 11-27-2007, 03:22 PM   #1
ga11ardo
Registered User
 
Join Date: Sep 2007
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
ga11ardo is on a distinguished road
creating and editing record in the same form

I have a form where the user can create a new order. The user input a PO and then a unique orderID is created. there is a subform on the form which is linked through the OrderID which contain details about the order (contains different products, quantities, ect.)

Is there any way that this same form can also function as an order editor, where the user can select an PO and OrderID combination from a dropdown menu and have all the information about the order in both the form and the subform come up so they can edit it (ie. add products, add quantities)

Since the PO is not the unique ID, if i enter an existing PO it only creates another record witht he same PO. If i try and enter an existing OrderID, i am not allowed because it is an autogen field. So how I am able to bring up an existing record I do not know. I know that I could do this with another form; however, I am wondering if there is anyway to accomplish this in the same form.

i have provided all the relevant feilds on the main and subform

frmOrder

txtPO
control source: PO

OrderID
control source: OrderID (autonumber)

frmOrderDetail

txtOrderID
control source: OrderID (linked to main form)

txtOrderDetailID
control source: OrderDetailID

ga11ardo is offline   Reply With Quote
Old 11-28-2007, 12:42 AM   #2
ajetrumpet
Banned
 
Join Date: Jun 2007
Location: Universe - Local Group - Milky Way Galaxy - Orion Arm
Posts: 5,640
Thanks: 0
Thanked 100 Times in 47 Posts
ajetrumpet has a spectacular aura about ajetrumpet has a spectacular aura about
Send a message via MSN to ajetrumpet Send a message via Yahoo to ajetrumpet
Quote:
Originally Posted by ga11ardo View Post
Is there any way that this same form can also function as an order editor, where the user can select an PO and OrderID combination from a dropdown menu and have all the information about the order in both the form and the subform come up so they can edit it (ie. add products, add quantities)
Sure there is, but why would you want to add the OrderID in with this? It is an autonumber, so it would have no significance to a user. The purpose of a PO is to issue an order, so wouldn't there only be 1 PO per order ID? That's what I would think anyway.

The thing to do for something like this is to create a switchboard form (auto or manual) that pop-ups on LOAD of the application itself. Put a couple of buttons there, one for opening the form in EDIT mode, with a WHERE criteria, based an inputting PO value from the user, and the other button for opening the form in DATA ENTRY mode. Something like this would be ideal for a user, as it shows them which choices they have to go for (via the switchboard) before they even open the form.
ajetrumpet is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Form plus table question Polly_G Forms 3 01-19-2006 06:03 AM
Editing records with forms Bobadopolis Forms 2 10-24-2005 02:26 AM
[SOLVED] editing tables through a form je27 Forms 0 10-21-2004 02:26 PM
Find a specific record in a form for editing CoddFish Forms 1 07-21-2003 11:31 PM
Editing SQL data on an Access form chris_visible Forms 1 07-12-2002 01:07 PM




All times are GMT -8. The time now is 08:48 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World