Hi all,
I am in the process of trying to create a front end for a MS SQL database, I tried doing something web based on the intranet, and then Power Apps (which did work, but there will be a cost attached to it and I don't need it internet accessible) and then a friend said about doing it in Access, which makes sense for what I need and how it will be used.
So far I have the SQL data connected and it reads it fine, I have a simple form that has a working search box that pulls through the data I need it to into a list box, but what I need is for an On Click event to then display the fields from that selected record. I have tried to use another list box but I am not sure if I am doing it correctly. Also I am not sure if I need to use a separate query to pull through a lot more fields that are in the search query.
I'm sure its something simple that I am missing.
Cheers...
I am in the process of trying to create a front end for a MS SQL database, I tried doing something web based on the intranet, and then Power Apps (which did work, but there will be a cost attached to it and I don't need it internet accessible) and then a friend said about doing it in Access, which makes sense for what I need and how it will be used.
So far I have the SQL data connected and it reads it fine, I have a simple form that has a working search box that pulls through the data I need it to into a list box, but what I need is for an On Click event to then display the fields from that selected record. I have tried to use another list box but I am not sure if I am doing it correctly. Also I am not sure if I need to use a separate query to pull through a lot more fields that are in the search query.
I'm sure its something simple that I am missing.
Cheers...