Forms and Subform

[Sed]

Hi,
Would somebody please help? I’m not a code writer any means. Here’s the issue. I have a form and within that form I have a subform that’s pulling form a query. The form has an auto number. The subform has an Authorization number field that they input according to the auto number that is assigned to them. All I want to do is to only display the record according to the Auto number. Right now, it’s displaying all the records per each authorization number.

 

[Sed]

Here's my db. If you go to the main form you will see what i'm talking about. Thank you very much.

 

[boblarson]

Well, since we don't have the SQL Server database with dbo_Supplier and dbo_Part, it will be very difficult to look at it.

 

[Sed]

Hmmm, not sure I understand. I open my attachment and I see it on there. Are you saying that the link to the SQL is not there when you open the DB?

 

[boblarson]

Hmmm, not sure I understand. I open my attachment and I see it on there.

Of course YOU do, because you are on your network with the SQL Server database there.

Are you saying that the link to the SQL is not there when you open the DB?

The SQL Server Database resides on YOUR network. We do not have your SQL Server database with us and it isn't like you can just send it to us.

However, what you COULD do, is to copy the SQL Server Table but select Definitions Only for the options. Then use a query to pull out enough records that apply to your situation and put them in that copied table. Then delete the SQL Server table from the database window and rename the copied table to be the same name as the SQL Server Database one. Then the forms can find a table that they think is the same table and we have a little data to work with.

Make sure that any data you supply is not sensitive and if it is, you can modify it in order to make it not be real, but at least be there so we can help diagnose the problem.

 

[Sed]

OK, Let me try that.

 

[Sed]

Boblarson,

Here is the new DB.

 

[boblarson]

Okay, that helped. Open the form now from the attached, revised sample. It should be doing what you want. You also needed criteria on the subform query so check out the query underlying the subform and the criteria I used.

 

[Sed]

OK, that worked. Thanks. One more question. I've added a new tab called "Parts Input" tab and I want that tab to have the look at my input table. is it possible?

 

[boblarson]

It might but if you have the same table opened elsewhere on the form it can conflict with each of them.

 

[Sed]

Can you tell me the best way to do this. I have 10 - 15 people who order parts on a daily bases. All I wan them to do is list the part num, PremQty and reason, why they are ordering prem freight. then input them into a table.