R
Revned
hi,
i have a form bound with a query
and my query has this SQL
SELECT tblItem.ItemCode, tblItem.CategoryID, tblItem.ItemDescription,
tblItem.Price, tblItem.Taxrate, tblDrinkingWaterType.TypeCode,
tblDrinkingWaterType.TypeName
FROM tblDrinkingWaterType INNER JOIN tblItem ON
tblDrinkingWaterType.TypeName = tblItem.TypeName;
i have a cmdNewItem button, i want that when i click from this button it
allows me to add new items to this "NewItem" form
i have also set Data Entry, Allow Edits, Allow Additions to Yes
i do attempt to write this code to cmdNewItem button but i have this error
i am using access 2003
DoCmd.GoToRecord , "New Item", acNewRec
Run Time Error 2489'
The object "NewItem'isn't open
thanks for any help i appreciate
i have a form bound with a query
and my query has this SQL
SELECT tblItem.ItemCode, tblItem.CategoryID, tblItem.ItemDescription,
tblItem.Price, tblItem.Taxrate, tblDrinkingWaterType.TypeCode,
tblDrinkingWaterType.TypeName
FROM tblDrinkingWaterType INNER JOIN tblItem ON
tblDrinkingWaterType.TypeName = tblItem.TypeName;
i have a cmdNewItem button, i want that when i click from this button it
allows me to add new items to this "NewItem" form
i have also set Data Entry, Allow Edits, Allow Additions to Yes
i do attempt to write this code to cmdNewItem button but i have this error
i am using access 2003
DoCmd.GoToRecord , "New Item", acNewRec
Run Time Error 2489'
The object "NewItem'isn't open
thanks for any help i appreciate