473,493 Members | 2,254 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

You cannot add or change a record because a related record in required in table

25 New Member
I am using a combo box to pull a persons name from a table. When the tables link personID and personFK table I get the message above when I close the form. You can see the record on the form. When I break the table link the form closes without error messages but none of the record are stored in the table.

I great appreciate your help.
Thanks in advance.
Nov 24 '15 #1
1 1553
TheSmileyCoder
2,322 Recognized Expert Moderator Top Contributor
This is usually the message you see when you are trying to add a record to the many side of a join, where the 1 side of the join doesn't exist yet. This can happen if you start typing in a subform, before entering something in the main form.

I don't really understand your question well enough to advice further. Could you provide a screenshot of your form in design view, clearly marking the combobox in question?
Nov 24 '15 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

5
2604
by: Andrew | last post by:
Hi All, Have come across something weird and am after some help. Say i run this query where rec_id is a column of table arlhrl, select * from arlhrl where rec_id >= 14260 This returns to...
1
1150
by: milkyway | last post by:
Hello to all, I have a table. I am trying to get a value out of a table but it is not working. What is the problem? If I put an INPUT field into a cell of a table, what operations should I do...
0
3179
by: elvin | last post by:
Okay - apologize in advance for the length, but I want to make sure all you knowledgeable and helpful people have all the details you need to hopefully point my newbie rear in the right direction....
2
3034
by: Colm O'Hagan | last post by:
Hi there, I having a problem with a database I'm setting up, I would be delighted if someone out there could help. The database I'm setting up is a task register datebase, it will be used to...
4
4038
by: amywolfie | last post by:
I've been trying to do something for about 3 days – I get close, but not 100%. I am trying to: Open frmRevisionHistory from a button on frmFeeInput. If there is NO RELATED RECORD, then I...
0
3556
by: André | last post by:
Hi, Still the same (unsolved problem), but other error now. I have a detailsview for inserting data, and a dropdownlist which selectedValue must be used to fill one of the field of the...
4
24329
by: Craggy | last post by:
I need to be able to add a record directly into a table using vba. The table is not the same table that is being used on my current form. Basically I want to have a question with a list box...
4
3082
by: PW | last post by:
Hi, I set up a relationship between two tables with the itineraryid fields in both tables: tblDailyItinerary tblDailyMeals I have a form that writes a record to tblDailyItinerary that...
4
2377
by: Knowlton | last post by:
I have a form for entering tire change records that has been working fine for several years. There are two records created for each tire change, one for the tire that was removed and another for...
5
1133
by: RadioWriter | last post by:
ADODB.Recordset Related record required Hi all- I'm working on a tool that exports worksheets from Excel to Access tables. On an Update statement, I'm getting the following message: "Run-Time Error...
0
7119
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
1
6873
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7367
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5453
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4889
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4579
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3088
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1400
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.