Recent content by juniorz

Thanks, i tried your code however I receive the following error: "The expression On Format you entered as the event property setting produced the following error: Ambiguous Name detected: Detail_Format" What did I do wrong?

Hi, I have a report that varies in length depending on how many records are placed in it. i want to add rectangles to neaten the records into tables, however if there are no records then i dont want the rectangle objects to show. Is there a way i can hide rectangle if the field doesn't have a...

Thanks for your help with this, i solved the issue by going to what pbaldy originally said and creating the combo as criteria and modifying the listbox row source. Seems to have worked quite well.

right, could it possibly be the problem is where the combobox is getting its information from? This is going through a table.

AGND would refer to a staff code or in this case a selection from the combobox

unfortunately I cant upload database due to confidentiality of people in it. i have taken these screencaps however. e1: once i choose a selection from the dropdown box this is what appears twice, I need to put in that staff code twice to populate the list. e2: a snap of the query the sql is...

interesting development, so I have changed the code to match Paul. Once i select a name from the drop down menu, a box appears asking for the staff id code, i type in the code, and it asks me for a code again, typed it in again and received another box asking for another input however this time...

removed it however when I try and run it, i receive a box asking to enter parameter queries.

i think i see my issue, I need the listbox to be populated by just the subject name, where the combo is saying it wants the list to be the staff ID. I want the combo which contains the staff ID to populate the listbox with only the subject name. Im just not sure how to write that using the sql.

both boxes are set to 1, do I need to set anything up on the listbox? i.e control source or row source in order for it to read from the combo?

ok, so i have modified it to this to try and fix the sql. Me!List2.RowSourceType = "Table/Query" Me!List2.RowSource = "Select [AT Class select query].[Subject Name] From [AT Class select query].[Subject Name] Where [AT Class select query].[Staff ID] = " & Me![Combo0] When I select a name, it...

Hi all, having trouble trying to get this too work. Im creating a DB where a form contains a dropdown combo box, staff will select their name and once selected a listbox below will populate with their classes. currently i am using this: Me!List2.RowSourceType = "Table/Query"...

Sorry for my incompetence, will get there shortly. DoCmd.OpenForm "NEP", , , "[Student Name] = '" & Forms!Nepchoice![Student Name] & "'" I corrected the code only to receive an error stating that access cannot find the referenced [Student Name]. Therefore as i am talking about the listbox in...

The form that the listbox should open is "NEP" the form that contains the listbox is called "Nepchoice" would that mean this should be changed? DoCmd.OpenForm "NEP", , , "[Student Name] = '" & Forms!NEP![Student Name] & "'"