Issue with a sub form popping up when it shouldn't

[Somullins]

Hello,

I have a a sub form within one of my forms to populate to fill out multiple records. I have a button command to have another sub form appear if it's needed for that record. However, once a selection is made in a combo box, this makes another sub form appear. There isn't any event built to make this happen so I am clueless as to how to make this stop. Any suggestions or ideas?

 

[RainLover]

Logic says there must be some code somewhere.

Use Ctrl F for find to locate the form name. Do this in a Module.

You should be able to find something.

 

[Somullins]

I searched the entire module and couldn't find any code.

 

[RainLover]

Is there a Macro.

When searching did you search the whole Project not just the Form's module.

 

[Somullins]

I searched the whole project.

 

[Somullins]

Here is the db. I could have completely overlooked it.

 

[RainLover]

I can't help with 2007. Can you save as 2003 and reattach.

Thanks

 

[Somullins]

Sorry about that. Here is the 2003 version

 

[RainLover]

It failed to attach.

 

[Somullins]

Trying this again

 

[Somullins]

Okay here it is finally

 

[RainLover]

Not there.

Did you hit the right buttons.

 

[RainLover]

Got it. Will have a look very soon.

 

[RainLover]

Your Design requires a redo. That is the Table design. You need to follow some naming conventions.

I would suggest that the Primary Key be AutoNumber. Don't use Spaces in any name.

Create all of your Relationships.

The use of the word File is incorrect. I think you mean Primary Key or Foreign Key.

On the Form and Sub Form I looked at, the first one, you have both forms set for Data Entry = Yes.

This will prevent you from viewing already entered records.

Can you have a look at that.

I need to go out for a while. I will have another look upon my return.

If anyone else has an Idea Please jump in.

 

[Somullins]

Where is the word File being used?

I changed the Data Entry Properties back to no, changed all of my naming conventions and set my Primary Key to an auto number as you suggested.

I appreciate all of your help. This is a hand me down project that a co-worker left the company and didn't finish. I am new to Access and feel lost.

 

[RainLover]

Sorry about the Field thing.

I got you cross wired with another Post.

I have a little spare time now so I will reLook at your problem.

 

[RainLover]

Hello,

I have a a sub form within one of my forms to populate to fill out multiple records. I have a button command to have another sub form appear if it's needed for that record. However, once a selection is made in a combo box, this makes another sub form appear. There isn't any event built to make this happen so I am clueless as to how to make this stop. Any suggestions or ideas?

Now that I have a copy of your Database, walk me to the problem.

I have a Green and Blue Form Titled Univita Referral Database opened.

What do I do next. I need to see the error.

 

[Somullins]

I found it! There was a command button hiding behind the subform. I was missing it thinking it was the code for the command button I built.

Thank you so much for all your help!!

 

[RainLover]

I am glad that one got sorted.

Good Luck with the project.