I need help with data input

[ngluvakov]

I made a table containing following fields:


In number of edits I enter integer value. Tied to this table is another where I enter who did work and on what edit number:

I need to restrict this entry to value less or equal to the value in previous table. How to make that? At this moment I can type in any value and it would work.

Thank you guys in advance. This is my first encounter with access and this forum. I am grateful on your time.

[ranman256]

in a continuous entry form, have the the limit value show in a textbox in the header.
The query for the form would pull both table data.
in the main entry form, set the BeforeUPDATE event for tWorkDone.EditNumber textbox.

sub EditNumber_BeforeUpdate(Cancel As Integer)
if  EditNumber  > me.txtLimit then
   msgbox "You cannot enter value larger than " & me.txtLimit
   cancel = true
endif
end sub

[ngluvakov]

Thank you for answer Ranman256. Where do I input the code? I have tried to put calculated in data type, but it doesn't work or recognize expressions. For now, I only know how to use GUI. That's the reason why my interaction with the software is very limited.

[andy49]

In the properties window, look for beforeupdate.

Click on add code and add the case in the window that opens.

[ngluvakov]

Thank you all for your help! This forum is really good!

I have tried, but it doesn't work. I found it only under form events. Does it mean that I can't have it in table? I am including the database.
Test.zip

[aytee111]

What have you tried? Your database doesn't seem to contain any of the above suggestions.