Search results

Okay i have managed to resolve this by inserting a subform into my form which generates the correct make & model name. However if anyone manages to amend my original vba code to do this without all this messing about please post up as i would love to be able to do it without this messing about.

Okay i have created the relationships from scratch and have managed to get the names showing in a query. Now trying to display this on a text field in my form but all i get is #Name? Is there something that i am missing here?

In fairness the IMEI is a short text field but IMEI's in general are unique. As for the relationships i have inherited this repair database which i have had to amend and make changes to in order to be fit for purpose. As far as i can see this database has no such relationships in place and...

i tried doing a query without much success. i was hoping that the code i have which working to a point that someone could help me go that little bit further with it

A continuous form is not going to work here. The stock is recorded on a separate database and I am building a repair database to track faults/repairs. This is why I need to pull the information from the other table. The form would be based on a different table altogether. Hope that clears...

Hey all, I am having issues trying to pull the make & model of a phone from another table. I have the following code that when a user inputs the IMEI of a device it goes away and pulls the Make ID(CatergoryID) and the Model ID(ItemID) and then populates those values on my form. Private Sub...