Form displays query result plus data entry field

CMD

Registered User.
Local time
Today, 16:40
Joined
Jun 5, 2012
Messages
20
I apologize right now if this question is already out there, but I have not been able to search the right words or something. I have been able to research most of my questions so far but this one has me stumped!:banghead:
Here goes: I have a DB that has 2 'sides', one side has estimated materials the other side is for actual materials used. What I want to do is create a form that displays (locked, cannot be changed) the estimated materials from my materialsjob table and a duplicate data entry field that can be edited if necessary. The data entry field would populate the ordermaterials table.
I hope I have managed to describe this in a way that makes sense to someone besides myself! Thanks in advance!
 
How about just placing two subforms side by side (or whatever) on a "main" form. One of the subforms would have the Allow Additions/Edits/Deletions properties set to No.
 
Sometimes the solution just seems so obvious, I was definitely overthinking this one!!
Thanks, I will give that a try!
 

Users who are viewing this thread

Back
Top Bottom