Can't add or change a record coz ...etc (error message)

2012-12-03  Source: Original Site  Category:Access  Views:0 

Advertisement

Hi

Problem summary:
I get this err message when I try to add a new record into a form\subform:

((Can't add or change a record because a recordset is required in table stock))

Details:

My database is made up of 3 tables

stock (*stockID, name, qty, etc) ---> stockID is autonumber
customer(*customerID, name, etc) --> customerID is autonumber
invoice (*invoiceID, stockID, customerID, etc) --> invoiceID is autonumber, stockID & customerID is a number (not autonumber)

I made a query (qryinvoice) that has all Invoice fields + other related fields in customer&stock tables

When I enter data into the query it accepts all input without any problems

I made a form with subform, the form is based on the query (qryinvoice), I made the childform linked 2 the master form using the InvoiceID field, that is Master field & Child field is InvoiceID

When I run the form, it shows the previously entered records fine, but when i try to enter new data, it works fine in the master form but once I try to go to the child form this error message pops up by the 'office assistant' which says:

Can't add or change a record because a recordset is required in table 'stock'.

BTW: the InvoiceID in the child form shows as an Autonumber ..is this the problem? or what?

Note: The autonumber of the invoiceID in the master form is generated perfectly, but I don't see it in the Child form when T try to go there.

Any help is highly appreciated.

Related articles
  • Can't add or change a record coz ...etc (error message) 2012-12-03

    Hi Problem summary: I get this err message when I try to add a new record into a form\subform: ((Can't add or change a record because a recordset is required in table stock)) Details: My database is made up of 3 tables stock (*stockID, name, qty, etc

  • You cannot add or change a record because 2013-03-21

    After some simple code I'm using ODBC I have several tables, more than what I'll list here Person Address State Country State is a field in Address which is a FK to Abbreviation, the PK in the table State The issue I have is, you enter data in a form

  • Oracle How to bold or change the color of the error messages 2012-04-30

    I need to either change the font or bold the error messges or change the color of the error messages that getting displayed. How can i do that?

  • Oracle Change the Duplicate Submission Page Error Message 2014-02-09

    How do I change the duplicate page submission error message in apex? I currently have it going to another page, but I want to change the error message. It currently has a linked continue Error ERR-3331 The page was already submitted and cannot be res

  • Where can I find more info on uvsh warning and error message 2014-06-25

    DataStage 7.5.1A on SuSe 9 on SGI Altix 330 Where can I find more information about uvsh warning and error messages? Does any one know how the following warning message is generated during Datastage installation. Warning: command 'uvsh LONGNAMES ON N

  • Ubuntu Cannot open package manager or add/remove programs.... weird error message 2014-05-08

    Hi, I recently switched to Ubuntu after being extremely frustrated with windows in general and overall I am very pleased. But lately I have been having some major problems. I tried to install the package that makes the OSX type dock, and I got severa

  • Ubuntu Can see home network but....gets error message 2012-04-06

    Been comparing Kubuntu and Ubuntu all day. (swapping drives) My problem is a simple one I hope, but I'm a Linux and networking NOOB. Here is the problem: Kubuntu sees and accesses my windows network right off of install while Ubuntu can see the netwo

  • Ubuntu can't log in except as root - lots of error messages 2012-05-07

    I am pasting together a couple e-mails here and it's late, so my apologies if something doesn't make sense. This is not a GNOME issue since I install KDE and that doesn't work either, but I was trying to fix a 915resolution issue I was having with th

  • how do you change the language of the error messages? 2012-07-26

    I have a question about setting the language in which you would like to get error messages in. I went into my MySQL using this command.... c:\mysql\bin\mysql -u root - h localhost ..... then I inputted this, hoping to change the language..... mysqld

  • Can't loop and change all records 2012-01-04

    I'm trying to loop through all records and clear a field. I've tried this: Dim bOk As Boolean Dim StrForm As String Dim cn As ADODB.Connection Dim Rst As ADODB.Recordset Dim StrDb As String Dim sngTask As Single Set cn = CurrentProject.Connection Set

  • Oracle 2 GB of space but can't add 70K LOB due to 01691 LOB Error 2015-04-10

    We're experiencing a strange problem at a customer site. We're getting a "ORA-01691: unable to extend lob segment" error when adding a row which includes a LOB of some 70K. However the tablespace is 2GigaByes and less than 1% full! All the suggestion

  • Ubuntu Can't run anything on wine I get an error message 2012-08-14

    guys Ive been trying to run apps such as utorrent and rapidownload and I always get the same error message. [/home/babu/Desktop/utorrent.exe] End-of-central-directory signature not found. Either this file is not a zipfile, or it constitutes one disk

  • HELP: can't access Mysql on Windows 7 but no error messages, browser just hangs 2013-12-30

    I've intalled PHP 5 and MySQL on Windows 7. php_info works and shows mysql and mysqli loaded. I've configured php.ini specifying the ext directory, uncommented the mysql dlls. I made sure the Windows path has the php and mysql directories as well as

  • Ubuntu Reinstall of HH can not add users 2015-06-03

    I reinstalled HH and did not format the seperate home directory. Now I can't add the other users I get an error message that the home directory already exists. What is the work around

  • Broke my DB :( can you help? - You cannot add or change 2013-11-12

    Hi I don't know what happened but when trying to add a record to a subform I get the following error: You cannot add or change a record because a related record is required in table 'tbl_Client-- I only have tbl_Client. tbl_Client-- was a duplicate t

  • Can I add fields to the UCMUtilityActivity record type with packageutil? 2014-04-16

    We're running v7.0.1 which is UCM enabled and multisited. One of our customers has asked for notification when code is delivered to the integration stream. They would also like a field on the defect populated (with a timestamp) as well. Can I add fie

  • add fadein to jquery validate error messages 2014-02-03

    How to add fadein() in the jquery validate label error messages? I've tried the following: $("label.error").hide().fadeIn("slow");$(this).hide().fadeIn(1000); but neither of them work. Can anyone please help me? Thank you. The code I've used: $(docum

  • Oracle Change default error messages 2012-09-09

    I want to change the default error message in apex. for example I wanna change the Not-Null default error message so instead of "Field1 must have some value" I wanna get "Field1 must not be null".

  • Ubuntu Add/Remove is giving me odd error messages... 2013-08-07

    I did a clean install of Ubuntu v6.06 a few weeks ago. The only tinkering I've done was to run EasyUbuntu and get XGL working. Now I (personally) am not a fan of *ANY* of the Ubuntu games and I wanted to remove them. Yet whenever I try to uncheck the

  • still can't add record 2012-11-28

    I am using this script to add a record. I keep running into the 'can't add record' error.. what should I change? <? if ((!$userid) || (!$password)) { header("location: http://www.retroarts.com/placeshare2/mylogin.php"); exit; } mysql_connect("loal