Error on Second Record

P

pfm721

I have a form that has a subform on it. When a user creates a new record on
the main form and then goes to make a selection in a combo box on the subform
I get a message that says "The field is to small to accept the amount of data
you have tried to add. Try inserting or pasting less data." It works fine
until the user moves to a new record.
 
N

NetworkTrade

is the subform's field size out of sync with its underlying table's field size?
 
P

pfm721

Not that I can tell. It works fine as long as I am under the first record for
a patient. When I have a problem is when a second record is created for a
patient.
 
T

twr126

Problem solved. Parent field and Child field were different sizes. After I
edited to match, new record could be entered.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open main and sub form blank 1
delete sub and stay on same parent record 4
How many lines are in a continuous form 2
Please help - I need to separate data to two tables using one form. 0
Access Main form/Subform Navigation 0
Subform record coordination 2
Continous Forms and preventing a new record being created 2
Cascading ComboBox on SubForm 6

Top