dblayout
|
| Posted: 07/11/2003, 1:53 PM |
|
I have an Access file that has 6 fields. I have a form that wil lonly be used to Insert records (orders). Currently, when I start with an empty table, the 1st user to add an order works perfectly. The next time someone goes to the Order form, the order form now shows the 1st (& only) records in my ORDERS table and the Insert button does not show up. I need the fields on my Form to be empty and the INsert button to show up so another user can insert an order. What code amd I missing to accomplish this? Remember, there is NO CHange or Delete button for this update form.
Thanks
Chris
|
|
|
 |
DaveRexel
|
| Posted: 07/11/2003, 2:21 PM |
|
Chris
The Insert button not showing up is a surefire sign that the form is not in Insert mode ie CCS is detecting a Primary Key being sent somehow. I had this happen to me and re-made the form using the wizard and making sure the sending link/button did not send a PK.
Dave
|
|
|
|
DaveRexel
|
| Posted: 07/11/2003, 3:04 PM |
|
::
the WHERE clause/s in your datasource could also be selecting the 1st record. It's hard to tell without more information.
|
|
|
|
dblayout
|
| Posted: 07/13/2003, 2:17 PM |
|
The Where clause should not be selecting anything (obviously it could be though). I do not even want a where clause. As a matter of fact, I dont want ANY SQL EXCEPT the INSERT. I guess I should try forceing the Insert variable to True & see if that correctes. It may think it is in Update mode (I bet thats it).
|
|
|
|
|
