Solved Navigation SubForm opens another Form (1 Viewer)

[theDBguy]

what's the best way to update Default Value when txtProjectNumber is a text field? Currently if I enter a non-numeric value I will get the error in the field

What does the error say? If the field is Text, then it should accept numbers and letters for input.

 

[VzqCrs]

What does the error say? If the field is Text, then it should accept numbers and letters for input.

try it on the database you have, if you try to put in TBD or something like WD2232 it returns an error in the Project Number field

 

[theDBguy]

try it on the database you have, if you try to put in TBD or something like WD2232 it returns an error in the Project Number field

Okay, I'll try it later. But, which field/textbox are we talking about? Please remember I am not familiar with your database, so you'll have to give me some basic instructions, sometimes.

 

[VzqCrs]

Sorry about that, let me clarify

NavigationForm - Create New tab - frmRequests.txtProjectNumber = frmMultipleRequests.txtProjectNumber (and txtProjectDeliverables)
This part is what you sent me earlier and works well as long as I have numbers as values, but if I enter an alphanumeric value it returns an #Error in the Project Number field of frmMultipleRequests.txtProjectNumber

NavigationForm - Finish an Incomplete Request tab - Finish Req form with SubForm frmIncRequestsQ . this is where it's tricky and where I'm having the most issues

Target Form - Finish Req in which a combo selection is made from cboSelectReq
When selected frmIncRequestsQ is visible where Link Master Felds: cboSelectReq = Link Child Fields: frmIncRequestsQ.txtProjectNumber

when a mulitple request is being created from this level, the form should likewise carry the project number forward frmIncRequestsQ.txtProjectNumber = frmIncMultipleRequests.txtProjectNumber

Let me know if you need more clarification

 

[theDBguy]

Sorry about that, let me clarify

NavigationForm - Create New tab - frmRequests.txtProjectNumber = frmMultipleRequests.txtProjectNumber (and txtProjectDeliverables)
This part is what you sent me earlier and works well as long as I have numbers as values, but if I enter an alphanumeric value it returns an #Error in the Project Number field of frmMultipleRequests.txtProjectNumber

NavigationForm - Finish an Incomplete Request tab - Finish Req form with SubForm frmIncRequestsQ . this is where it's tricky and where I'm having the most issues

Target Form - Finish Req in which a combo selection is made from cboSelectReq
When selected frmIncRequestsQ is visible where Link Master Felds: cboSelectReq = Link Child Fields: frmIncRequestsQ.txtProjectNumber

when a mulitple request is being created from this level, the form should likewise carry the project number forward frmIncRequestsQ.txtProjectNumber = frmIncMultipleRequests.txtProjectNumber

Let me know if you need more clarification

Hi. Thanks for the additional information. I'll let you know later when I give it a try if I have more questions.

 

[theDBguy]

Hi. I'm sorry, I am not seeing exactly what you are seeing. For starters, when I open your file, this is what I get.

I click on the End button, and the Nav Form opens. If I enter "abc" in the Project #: textbox and hit the Tab key, then I get this error.

Is that how this is supposed to work?

 

[theDBguy]

As for the #Error, when I enter TBD as the project number and then click on the OK button, I don't get the error.

 

[VzqCrs]

Hi. I'm sorry, I am not seeing exactly what you are seeing. For starters, when I open your file, this is what I get.

View attachment 96194

I click on the End button, and the Nav Form opens. If I enter "abc" in the Project #: textbox and hit the Tab key, then I get this error.

View attachment 96195

Is that how this is supposed to work?

Yes, if exists, further down on the form the project deliverables location will be displayed

 

[VzqCrs]

Thank you, I'll give it a try in the morning and let you know how it goes.

 

[theDBguy]

Thank you, I'll give it a try in the morning and let you know how it goes.

I did eventually get the error but only because I entered more than six characters. It seems your main table is set to a max 8 char project number, but the related table is only set to 6 max.

 

[VzqCrs]

I did eventually get the error but only because I entered more than six characters. It seems your main table is set to a max 8 char project number, but the related table is only set to 6 max.

That worked to get rid of the error!

 

[theDBguy]

That worked to get rid of the error!

Good. What about the second tab? I still don't understand that part. I'll need a step by step instruction to duplicate that problem.

 

[theDBguy]

Hi. I think I managed to figure out what you mean by the second tab. Take a look at this...

 

[VzqCrs]

Hi. I think I managed to figure out what you mean by the second tab. Take a look at this...

You are fantastic!!! Thank you so much for helping me with this!

 

[theDBguy]

You are fantastic!!! Thank you so much for helping me with this!

You're welcome. Glad we could help. Good luck with your project.