Split Form trouble (1 Viewer)

silentwolf

Active member
Local time
Today, 13:28
Joined
Jun 12, 2009
Messages
653
Hi again guys!

it's been along time beeing here hope you all doing well!

I have a new work so that is why I had not much time beeing around for the last past year! But I am getting back into it and after spending a day on one form I am hoping to get some help from you guys.

I have attached a database where I would like to get a split form it is already included but it is not updateing data the way it should and I am stuck and a bit frustrated.

This is what I have at present.
tblMaterials, tblProfiles, tblMaterialProfiles as a junction table.

tblProfileDimensions, tblStorageLocations, tblStockInventory, and tblUnits

I like to create a splitform to enter StockInventories into and view all stock in the same Form.

Therefor a split form.

However due to so many links I am not beeing able to get it working. How to fill the comboboxes or to have it correctly displayed in the datasheet view.

In my Database I have included the form, functions, and all tables with linkes and queries.

So there is alot done but just not correct yet.
Could someone please have a look at it for me? Would be very much appreciated!

Many thanks

Albert
 

Attachments

Why bother with query as form RecordSource since it doesn't have multiple tables and there are no calcs and no filtering? Just bind to table.

Your code puts the first record into edit mode with Me.cboProfileDimensionID = Null. This is changing existing data. Since this combobox is BOUND, should not change its value unless a "parent" control data changes. Is this value dependent on data entered in another control?
 
Last edited:
1. There are some combos that have no defined record source. Are you having trouble defining these? What is the problem - you have defined the record source for other combos?
2. There are references to qryProfileDimensionDetails. That query does not exist in the db supplied
 
Good Morning and thanks for your replies.
I was hoping that someone could give me a query that I could use to get this split form up and running.
For me I had no luck so I was trying ways around it but without luck.

I like to be able to have a cascading Combo to choose Filter Profiles depanding on Material. Then choose what Profile Dimension is available for that material Profile. And finally record the StockInventory for that given Material-Profile with a certain Dimension. And what StorageLocation.

Thanks
 
I like to be able to have a cascading Combo to choose Filter Profiles depanding on Material. Then choose what Profile Dimension is available for that material Profile. And finally record the StockInventory for that given Material-Profile with a certain Dimension. And what StorageLocation.
They would need to be unbound controls.
Create a Form Header and put the controls in there.

Here is a similar form from one of my DBs. Whilst it is not split, I use a subform, the logic is the same.

1754030214465.png
 
They would need to be unbound controls.
Create a Form Header and put the controls in there.

Here is a similar form from one of my DBs. Whilst it is not split, I use a subform, the logic is the same.

View attachment 120773
Hi Gasman,

yes that would be also good! But as I mentioned somehow I was not able to get that happening.. either the combos did not filter correct or have been not filled correctly or filtered correctly and so on..
Is there a chance you could look at my situation and create a subform for me would that be possible please?
 
Sorry, I am not a developer and it takes me time to write code etc.
Just looking at what you have, there are bits missing anyway? No such query exists in that DB?
1754031553232.png

No such qry there?
I would get rid of the split form for now. get it working as it should, THEN turn it into a split form.
I can see you actually had Material and Profile unbound, but mised in with bound controls, which to me would be confusing to the user, even if that was just me, a few weeks down the line.

Plenty of example on here for cascading combos.
Also on YouTube
 
Sorry, I am not a developer and it takes me time to write code etc.
Just looking at what you have, there are bits missing anyway? No such query exists in that DB?
View attachment 120779
No such qry there?
I would get rid of the split form for now. get it working as it should, THEN turn it into a split form.
I can see you actually had Material and Profile unbound, but mised in with bound controls, which to me would be confusing to the user, even if that was just me, a few weeks down the line.

Plenty of example on here for cascading combos.
Also on YouTube
Ah ok sorry I created a blank database from what I had in my original Database. I know the cascading combo is maybe not the issue the issue comes done to the different linked tables what throws me off. I will add that query in a new Database maybe it is just a small thing but for me it is a big issue it seams.
But I understand you of course! No problem!
Thanks for pointing it out though!! Cheers
 
Ah ok sorry I created a blank database from what I had in my original Database. I know the cascading combo is maybe not the issue the issue comes done to the different linked tables what throws me off. I will add that query in a new Database maybe it is just a small thing but for me it is a big issue it seams.
But I understand you of course! No problem!
Thanks for pointing it out though!! Cheers
 

Attachments

Ok I am getting again somewhere )

Got the comboboxes sorted in the mainform and use now a subform to list all the entries on the StockInventory.
However the subform still not show the correct or all the fields in the subform.
Only some are missing and still need to work on that.
 
You need to match the controls and their sources to the fields in the source of the form.
 
I would suggest that it is easier to use a Main Form with Related Subforms to Manage this process.

See attached screenshot.
Hi Mike!
Yes that looks pretty good too I was just wondering how I can get it all working within the form!
Still struggling a bit with it. But was not here was working so just got back.
I will take a look at it again ! Cheers )
 
Hi Mike!
Yes that looks pretty good too I was just wondering how I can get it all working within the form!
Still struggling a bit with it. But was not here was working so just got back.
I will take a look at it again ! Cheers )
Hi
Here with the db attached
 

Attachments

Users who are viewing this thread

  • Back
    Top Bottom